Operation Details
Description: Determine the caseID, caseType and continueBenefitsIndicator for an appealed case.
Sterotype: ns
SQL 
SELECT
  AppealRelationship.caseID,
  continueBenefitsIndicator,
  caseTypeCode
INTO
  :caseID,
  :continueBenefitsIndicator,
  :caseType 
FROM
  AppealRelationship,
  CaseHeader 
WHERE appealRelationshipID = :appealRelationshipID 
  AND AppealRelationship.caseID = CaseHeader.caseID