Operation Details
Description: Returns the type and participated details for the latest hearing with the specified status for the specified appeal case.
Sterotype: ns
SQL 
SELECT
  typeCode,
  respondentParticipatedCode,
  thirdPartyParticipatedCode
INTO
  :typeCode,
  :respondentParticipatedCode,
  :thirdPartyParticipatedCode 
FROM
  Hearing 
WHERE caseID = :caseID 
  AND scheduledDateTime = 
  ( 
  SELECT
    MAX(scheduledDateTime) 
  FROM
    Hearing 
  WHERE caseID = :caseID 
    AND statusCode = :statusCode 
  ) 
  AND statusCode = :statusCode