Operation Details |
Description: | Count existing entries that match for estimatedCost, planItemID, statusCode, and userName. Essentially look for duplicate entries |
Sterotype: | ns |
SQL |
SELECT COUNT (*) INTO :recordCount FROM PlanItemApprovalCheck WHERE planItemID = :planItemID AND estimatedCost = :estimatedCost AND statusCode = :statusCode AND userName = :userName |