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 |