Operation Details
Description: Reads details, including versionNo, about all users of the specified type for the hearing.
Sterotype: nsmulti
SQL
SELECT
  CaseUserRole.orgObjectLinkID,
  recordStatus,
  participatedCode,
  typeCode,
  hearingUserRoleID,
  HearingUserRole.versionNo
INTO
  :orgObjectLinkID,
  :recordStatus,
  :participatedCode,
  :typeCode,
  :hearingUserRoleID,
  :versionNoOpt
FROM
  HearingUserRole,
  CaseUserRole 
WHERE hearingID = :hearingID 
  AND CaseUserRole.caseUserRoleID = HearingUserRole.caseUserRoleID 
  AND typeCode = :typeCode