| Operation Details |  |
| Description: | Reads the latest scheduled or completed date |
| Sterotype: | ns |
| SQL | |
SELECT
MAX(scheduledDateTime)
INTO
:scheduledDateTime
FROM
Hearing
WHERE caseID = :caseID
AND
(
statusCode = :adjourned
OR statusCode = :completed
)
|