Operation Details
Description: Counts the number of 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