Operation Details |
Description: | Read the most recent postponed hearing using the specified status for a case. |
Sterotype: | ns |
SQL |
SELECT hearingID, postponeDate INTO :hearingID, :postponeDate FROM Hearing WHERE caseID = :caseID AND statusCode = :statusCode AND postponeDate = ( SELECT MAX(postponeDate) FROM Hearing WHERE caseID = :caseID AND statusCode = :statusCode ) |