pears.GetTempName

CREATE FUNCTION "pears"."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