Operation Details
Description: Returns the hearing id and status, and the user type and status.
Sterotype: ns
SQL 
SELECT
  HearingUserRole.hearingID,
  statusCode,
  CaseUserRole.typeCode,
  recordStatus
INTO
  :hearingID,
  :statusCode,
  :typeCode,
  :recordStatus 
FROM
  HearingUserRole,
  Hearing,
  CaseUserRole 
WHERE hearingUserRoleID = :hearingUserRoleID 
  AND CaseUserRole.caseUserRoleID = HearingUserRole.caseUserRoleID 
  AND Hearing.hearingID = HearingUserRole.hearingID