pears.GetTempName

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."GetTempName" IS 
{CREATE FUNCTION GetTempName 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN persid CHAR(20))
RETURNS CHAR(60)
BEGIN
  DECLARE rv CHAR(60);
  SELECT string (IF EXISTS (SELECT * FROM wpkglobalswitchsetting WHERE wpkglobalswitchid = 'USEFULLNAME' AND location = 'Global' AND VALUE = 'Y') THEN person.name ELSE 
    ifnull(person.surname,person.name,string(person.surname,', ',firstword(person.forenames))) endif, 
    (SELECT string(' (',name,')') FROM company WHERE companyid = (SELECT secondaryagencyid FROM pay_employee WHERE personid = persid)) 
    ) INTO rv FROM person WHERE personid = persid;
  RETURN rv
END
}