Operation Details |
Description: | Counts the number of active record with a specified name. |
Sterotype: | ns |
SQL |
SELECT COUNT (*) INTO :recordCount FROM VerificationRequirementUsage WHERE name = :name AND verificationRequirementID = :verificationRequirementID AND recordStatus <> :recordStatus |