pears.GetTimeSheetDescription

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."GetTimeSheetDescription" IS 
{CREATE FUNCTION GetTimeSheetDescription 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN usesecags tinyint,IN persid CHAR(20),IN secagid CHAR(20),IN sdescrip long VARCHAR)
RETURNS long VARCHAR
BEGIN
  IF isnull(usesecags,0) = 0 OR persid IS NULL THEN
    RETURN isnull(sdescrip,'')
  END IF;
  IF secagid IS NULL THEN
    SELECT FIRST secondaryagencyid INTO secagid FROM pay_employee WHERE personid = persid
  END IF;
  IF secagid IS NOT NULL THEN
    SET sdescrip=string((SELECT FIRST name FROM company WHERE companyid = secagid),' ',sdescrip)
  END IF;
  RETURN isnull(sdescrip,'')
END
}