Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
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 }