Operation Details
Description: Reads the most recently postponed hearing for the specified case, for the specified date.
Sterotype: ns
SQL 
SELECT
  hearingID,
  postponeDate
INTO
  :hearingID,
  :postponeDate 
FROM
  Hearing 
WHERE caseID = :caseID 
  AND statusCode = :statusCode1 
  AND postponeDate = 
  ( 
  SELECT
    MAX(postponeDate) 
  FROM
    Hearing 
  WHERE caseID = :caseID 
    AND statusCode = :statusCode1 
    AND 
    (
      postponeDate >= :postponeDate 
      AND postponeDate < :nextDay 
    ) 
  )