Operation Details
Description: Retrieve the details for an appeal case which can be modified including the version numbers for both the Appeal and CaseHeader entities.
Sterotype: ns
SQL 
SELECT
  Appeal.appealID,
  Appeal.caseID,
  Appeal.comments,
  Appeal.difficultyCode,
  Appeal.versionNo,
  CaseHeader.versionNo,
  CaseHeader.receivedDate
INTO
  :appealID,
  :caseID,
  :comments,
  :difficultyCode,
  :versionNo,
  :caseHeaderVersionNo,
  :receivedDate 
FROM
  Appeal,
  CaseHeader 
WHERE Appeal.caseID = CaseHeader.caseID 
  AND Appeal.caseID = :caseID