| Operation Details |  |
| Description: | Returns the hearing ID and status for the latest hearing on the specified appeal case. |
| Sterotype: | ns |
| SQL | |
SELECT
hearingID,
statusCode
INTO
:hearingID,
:statusCode
FROM
Hearing
WHERE caseID = :caseID
AND scheduledDateTime =
(
SELECT
MAX(scheduledDateTime)
FROM
Hearing
WHERE caseID = :caseID
)
|