Operation Details |
Description: | Counts duplicate investigation resolution approval check records for an organization unit with no investigation specified. |
Sterotype: | ns |
SQL |
SELECT COUNT(*) INTO :numberOfRecords FROM InvestigationApprovalCheck WHERE investigationApprovalCheckID <> :investigationApprovalCheckID AND investigationConfigID IS NULL AND organisationUnitID = :organisationUnitID AND recordStatus = :recordStatus |