Operation Details
Description: Returns a count of the number of appeals of the specified type and status that are related to the specified case.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :recordCount 
FROM
  Appeal,
  CaseHeader 
WHERE CaseHeader.caseID = Appeal.caseID 
  AND Appeal.appealTypeCode = :appealTypeCode 
  AND CaseHeader.statusCode = :statusCode 
  AND Appeal.caseID IN 
  ( 
  SELECT
    relatedCaseID 
  FROM
    CaseRelationship 
  WHERE caseID = :caseID 
    AND typeCode = :typeCode 
  )