Operation Details
Description: Returns resolution details for each appealed case on a specified appeal. Only active and approved appealed cases are retrieved.
Sterotype: nsmulti
SQL 
SELECT
  caseReference,
  AppealRelationship.caseID,
  reasonCode,
  resolutionCode
INTO
  :caseReference,
  :caseID,
  :reasonCode,
  :resolutionCode 
FROM
  AppealRelationship,
  CaseHeader 
WHERE AppealRelationship.caseID = CaseHeader.caseID 
  AND AppealRelationship.recordStatus = :recordStatus 
  AND AppealRelationship.statusCode = :statusCode 
  AND appealCaseID = :appealCaseID