Operation Details
Description: Reads the appealCaseID and the overall appeal case status for the appeal relationship record.
Sterotype: ns
SQL 
SELECT
  AppealRelationship.appealCaseID,
  CaseHeader.statusCode
INTO
  :appealCaseID,
  :statusCode 
FROM
  AppealRelationship,
  CaseHeader 
WHERE AppealRelationship.appealRelationshipID = :appealRelationshipID 
  AND AppealRelationship.appealCaseID = CaseHeader.caseID