Operation Details
Description: Returns the number of appeal relationship records for an appeal case which have the specified resolution. Only active records are considered.
Sterotype: ns
SQL 
SELECT
  COUNT(appealRelationshipID)
INTO
  :recordCount 
FROM
  AppealRelationship,
  CaseHeader 
WHERE AppealRelationship.appealCaseID = :appealCaseID 
  AND AppealRelationship.resolutionCode = :resolutionCode 
  AND AppealRelationship.recordStatus = :recordStatus 
  AND AppealRelationship.statusCode = :statusCode 
  AND AppealRelationship.caseID = CaseHeader.caseID 
  AND caseTypeCode <> 'CT10'