Operation Details
Description: Returns the overall appeal decision for an appeal case.
Sterotype: ns
SQL 
SELECT
  hearingDecisionID,
  resolutionCode,
  decisionStatus,
  HearingDecision.versionNo,
  CaseHeader.statusCode
INTO
  :hearingDecisionID,
  :resolutionCode,
  :decisionStatus,
  :versionNo,
  :caseStatus 
FROM
  HearingDecision,
  CaseHeader 
WHERE HearingDecision.caseID = CaseHeader.caseID 
  AND HearingDecision.caseID = :caseID