Operation Details
Description: Returns all users, regardless of their status, for a hearing.
Sterotype: nsmulti
SQL 
SELECT
  CaseUserRole.orgObjectLinkID,
  recordStatus,
  participatedCode,
  typeCode,
  hearingUserRoleID
INTO
  :orgObjectLinkID,
  :recordStatus,
  :participatedCode,
  :typeCode,
  :hearingUserRoleID 
FROM
  HearingUserRole,
  CaseUserRole 
WHERE hearingID = :hearingID 
  AND CaseUserRole.caseUserRoleID = HearingUserRole.caseUserRoleID