Operation Details
Description: Reads the appeal type and case status of the specified appeal case.
Sterotype: ns
SQL
SELECT
  appealTypeCode,
  statusCode
INTO
  :appealTypeCode,
  :statusCode 
FROM
  Appeal,
  CaseHeader 
WHERE Appeal.caseID = :caseID 
  AND Appeal.caseID = CaseHeader.caseID