====== pears.NetProvTimesheetShiftCheckDates ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
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
}
</code>