pears.PersonUnavailabilityTimesheet

CREATE FUNCTION "pears"."PersonUnavailabilityTimesheet"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "pid" CHAR(20),IN "WorM" CHAR(1),IN "pPeriod" INTEGER,IN "dfrom" DATE,IN "dto" DATE ) 
RETURNS CHAR(200)
BEGIN
  DECLARE "ua" CHAR(100);
  SELECT "personunavailability"("pid",'T',"dfrom","dto") INTO "ua";
  IF "ua" = '' THEN
    IF EXISTS(SELECT "tempprovtimesheetid" FROM "tempprovtimesheet" WHERE "personid" = "pid" AND "periodlength" = "worm" AND "period" = "pperiod") THEN
      SET "ua" = 'Provisional Timesheets Entered'
    END IF END IF;
  RETURN("ua")
END