Operation Details |
Description: | Counts duplicate resolution approval check records for a user. |
Sterotype: | ns |
SQL |
SELECT COUNT(*) INTO :numberOfRecords FROM InvestigationApprovalCheck WHERE investigationApprovalCheckID <> :investigationApprovalCheckID AND investigationConfigID = :investigationConfigID AND userName = :userName AND recordStatus = :recordStatus |