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