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