Operation Details
Description: Reads the appeal relationship resolution details for modification where the a decision on a prior appeal case is being appealed.
Sterotype: ns
SQL 
SELECT
  AppealRelationship.caseID,
  CH.caseReference,
  AppealRelationship.priorAppealCaseID,
  CH2.caseReference,
  AppealRelationship.resolutionCode,
  AppealRelationship.versionNo
INTO
  :caseID,
  :caseReference,
  :priorAppealCaseID,
  :priorAppealCaseReference,
  :resolutionCode,
  :versionNo 
FROM
  AppealRelationship,
  CaseHeader CH,
  CaseHeader CH2 
WHERE AppealRelationship.appealRelationshipID = :appealRelationshipID 
  AND AppealRelationship.caseID = CH.caseID 
  AND AppealRelationship.priorAppealCaseID = CH2.caseID