Operation Details
Description: This operation returns back a count of approval criteria records that have the same criteriaName as that of the criteriaName passed in. This will help prevent duplicates being created.
Sterotype: ns
SQL
SELECT
  COUNT(*)
INTO
  :numApprovalCriteria 
FROM
  ApprovalCriteria 
WHERE ApprovalCriteria.criteriaName = :criteriaName 
  AND ApprovalCriteria.recordStatus = :recordStatus