Operation Details
Description: Returns the details needed to remove the appealed case from the appeal successfully
Sterotype: ns
SQL 
SELECT
  AppealRelationship.appealCaseID,
  AppealRelationship.caseID,
  AppealRelationship.priorAppealCaseID,
  AppealRelationship.statusCode,
  AppealRelationship.continueBenefitsIndicator,
  Appeal.appealTypeCode,
  AppealRelationship.deadlineDate,
  AppealRelationship.receivedDate
INTO
  :appealCaseID,
  :caseID,
  :priorAppealCaseID,
  :statusCode,
  :continueBenefitsIndicator,
  :appealTypeCode,
  :deadlineDate,
  :receivedDate 
FROM
  AppealRelationship,
  Appeal 
WHERE AppealRelationship.appealRelationshipID = :appealRelationshipID 
  AND AppealRelationship.appealCaseID = Appeal.caseID