Operation Details
Description: Retrieves product approval checks which match the details specified in the key.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :count 
FROM
  CaseApprovalCheck 
WHERE caseApprovalCheckID <> :caseApprovalCheckID 
  AND estimatedCost = :estimatedCost 
  AND 
  (
    productID = :productID 
  ) 
  AND 
  (
    typeCode = :typeCode 
  ) 
  AND statusCode = :statusCode