====== pears.NetCandidateProvTimesheetForApprovalCount ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Original SQL ===== create procedure "pears"."NetCandidateProvTimesheetForApprovalCount"( in "pWebUserID" char(20) ) result( "pResult" integer ) // IQXNet begin select "count"() from "NetTimesheetsForApproval"("pWebUserID") end go COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidateProvTimesheetForApprovalCount" IS {create PROCEDURE pears."NetCandidateProvTimesheetForApprovalCount"(pWebUserID char(20)) RESULT(pResult integer) // IQXNet BEGIN select count(*) from NetTimesheetsForApproval(pWebUserID) END }