Operation Details |
Description: | Reads duplicate case approval check records for an organization unit with no product specified. |
Sterotype: | ns |
SQL |
SELECT COUNT(*) INTO :count FROM CaseApprovalCheck WHERE caseApprovalCheckID <> :caseApprovalCheckID AND productID IS NULL AND estimatedCost = :estimatedCost AND organisationUnitID = :organisationUnitID AND statusCode = :statusCode |