| Operation Details |  |
| Description: | Counts the number of approved and active appealed cases which exist for an appeal case. |
| Sterotype: | ns |
| SQL | |
SELECT COUNT(*) INTO :recordCount FROM AppealRelationship WHERE AppealRelationship.appealCaseID = :appealCaseID AND AppealRelationship.recordStatus = :normalRecordStatus AND AppealRelationship.statusCode = :approvedStatusCode |