Operation Details |
Description: | Reads the status of the latest postponed hearing on the specified case. |
Sterotype: | ns |
SQL |
SELECT statusCode INTO :statusCode FROM Hearing WHERE caseID = :caseID AND postponeDate IS NOT NULL AND postponeDate IN ( SELECT MAX(postponeDate) FROM Hearing WHERE caseID = :caseID ) |