pears.NetProvTimesheetShiftCheckDates

CREATE PROCEDURE "pears"."NetProvTimesheetShiftCheckDates"( IN "pWebUserID" CHAR(20),IN "pTempProvTimesheetID" CHAR(20) ) 
RESULT( "startdate" DATE,"enddate" DATE ) 
BEGIN
  SELECT "weekmonthstartdate"("period","periodlength") AS "startdate",
    "weekmonthenddate"("period","periodlength") AS "enddate"
    FROM "tempprovtimesheet"
    WHERE "tempprovtimesheetid" = "pTempProvTimesheetID"
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetProvTimesheetShiftCheckDates" IS 
{CREATE PROCEDURE pears."NetProvTimesheetShiftCheckDates"(IN pWebUserID CHAR(20),IN pTempProvTimesheetID CHAR(20))
RESULT(startdate DATE, enddate DATE)
BEGIN
    SELECT 
        weekmonthstartdate(period,periodlength) AS startdate,
        weekmonthenddate(period,periodlength) AS enddate 
    FROM 
        tempprovtimesheet 
    WHERE tempprovtimesheetid=pTempProvTimesheetID;
END
}