Operation Details
Description: retrieves the number of appealed issues on an appeal case.
Sterotype: ns
SQL 
SELECT
  count(*)
INTO
  :numberOfRecords 
FROM
  AppealRelationship,
  CaseHeader 
WHERE AppealRelationship.appealCaseID = :appealCaseID 
  AND AppealRelationship.caseID =CaseHeader.caseID 
  AND caseTypeCode = :caseTypeCode