pears.weekenddate

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