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 |