Operation Details |
Description: | Reads duplicate evidence approval check records for a user where no product is specified. |
Sterotype: | ns |
SQL |
SELECT COUNT(*) INTO :counter FROM EvidenceApprovalCheck WHERE evidenceApprovalCheckID <> :evidenceApprovalCheckID AND productID IS NULL AND organisationUnitID = :organisationUnitID AND recordStatus = :recordStatus |