pears.weekenddate

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."weekenddate" IS 
{CREATE FUNCTION weekenddate 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN pyearno INTEGER,IN pweekno INTEGER)
RETURNS DATE
BEGIN
  DECLARE rv DATE;
  SELECT week1friday INTO rv FROM payrollyear WHERE yearnumber=pyearno;
  IF rv IS NULL THEN
    SELECT week1friday+(numberofweeks*7) INTO rv FROM payrollyear WHERE yearnumber=pyearno-1
  END IF
  ;
  IF rv IS NOT NULL THEN
    SET rv=rv+((pweekno-1)*7)
  END IF
  ;
  RETURN(rv)
END
}