Operation Details
Description: Returns the resolution, caseID and case reference for an appealed case.
Sterotype: ns
SQL 
SELECT
  AppealRelationship.resolutionCode,
  AppealRelationship.caseID,
  CaseHeader.caseReference
INTO
  :resolutionCode,
  :caseID,
  :caseReference 
FROM
  AppealRelationship,
  CaseHeader 
WHERE AppealRelationship.appealRelationshipID = :appealRelationshipID 
  AND AppealRelationship.caseID = CaseHeader.caseID