| Operation Details |  |
| Description: | Counts the number of active Appeals on a case. |
| Sterotype: | ns |
| SQL | |
SELECT COUNT(*) INTO :numOfRecords FROM AppealRelationship WHERE AppealRelationship.caseID = :caseID AND AppealRelationship.recordStatus = :recordStatus |