Operation Details
Description: Reads details about all users of the specified type for the 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 
  AND typeCode = :typeCode