Operation Details
Description: Method to count the number of cases that are awaiting approval for a specified supervisor user.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :numberOfRecords 
FROM
  CaseApproval,
  CaseHeader 
WHERE CaseApproval.userName = :userName 
  AND CaseApproval.methodCode = :methodCode 
  AND CaseApproval.approvalStatus = :approvalStatus 
  AND CaseApproval.approverTypeCode = :approverTypeCode 
  AND CaseHeader.statusCode = :caseStatusCode 
  AND CaseHeader.caseID = CaseApproval.caseID