Operation Details
Description: Retrieve the list of decisions for the appeal case
Sterotype: nsmulti
SQL 
SELECT
  resolutionCode,
  CaseHeader.caseID,
  caseReference
INTO
  :resolutionCode,
  :caseID,
  :caseReference 
FROM
  AppealRelationship,
  CaseHeader 
WHERE appealCaseID = :appealCaseID 
  AND recordStatus = :recordStatus 
  AND AppealRelationship.caseID = CaseHeader.caseID