Operation Details
Description: Returns the resolution code for an appealed case together with the caseID, the caseReference for the caseID, priorAppealCaseID and the case reference for the prior appeal case.
Sterotype: ns
SQL 
SELECT
  AppealRelationship.resolutionCode,
  AppealRelationship.caseID,
  AppealRelationship.priorAppealCaseID,
  CH.caseReference,
  CH2.caseReference
INTO
  :resolutionCode,
  :caseID,
  :priorAppealCaseID,
  :caseReference,
  :priorAppealCaseReference 
FROM
  AppealRelationship,
  CaseHeader CH,
  CaseHeader CH2 
WHERE AppealRelationship.appealRelationshipID = :appealRelationshipID 
  AND AppealRelationship.caseID = CH.caseID 
  AND AppealRelationship.priorAppealCaseID = CH2.caseID