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 ServicePlanGroupApprovalCheck WHERE servicePlanGroupID = :servicePlanGroupID AND estimatedCost = :estimatedCost AND statusCode = :statusCode AND userName = :userName |