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