Operation Details
Description: Count existing entries that match for estimatedCost, planItemID, statusCode, and userName. Essentially look for duplicate entries
Sterotype: ns
SQL
SELECT
  COUNT (*)
INTO
  :recordCount 
FROM
  PlanItemApprovalCheck 
WHERE planItemID = :planItemID 
  AND estimatedCost = :estimatedCost 
  AND statusCode = :statusCode 
  AND userName = :userName