| Operation Details |  |
| Description: | Returns the hearing decision status and the case status of the associated appeal case. |
| Sterotype: | ns |
| SQL | |
SELECT decisionStatus, statusCode INTO :decisionStatus, :statusCode FROM HearingDecision, CaseHeader WHERE HearingDecision.caseID = CaseHeader.caseID AND hearingDecisionID = :hearingDecisionID |