Operation Details
Description: Returns the decision date, decision resolution and the appeal case reference for the decision for the appeal case.
Sterotype: ns
SQL 
SELECT
  decisionDate,
  resolutionCode,
  caseReference
INTO
  :decisionDate,
  :resolutionCode,
  :caseReference 
FROM
  HearingDecision,
  CaseHeader 
WHERE HearingDecision.caseID = CaseHeader.caseID 
  AND HearingDecision.caseID = :caseID