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