Operation Details
Description: Retrieves details for a schedule notice for a hearing on the specified appeal case.
Sterotype: ns
SQL 
SELECT
  Hearing.scheduledDateTime,
  CaseHeader.receivedDate
INTO
  :scheduledDateTime,
  :receivedDate 
FROM
  Hearing,
  CaseHeader 
WHERE Hearing.caseID = :caseID 
  AND Hearing.statusCode = :scheduled 
  AND CaseHeader.caseID = Hearing.caseID