Operation Details
Description: Searches for the caseUserRoleID, userName and full name details for hearing users of a specified role for a hearing.
Sterotype: nsmulti
SQL 
SELECT
  CaseUserRole.caseUserRoleID,
  CaseUserRole.orgObjectLinkID
INTO
  :caseUserRoleID,
  :orgObjectLinkID 
FROM
  CaseUserRole,
  HearingUserRole 
WHERE CaseUserRole.caseUserRoleID = HearingUserRole.caseUserRoleID 
  AND CaseUserRole.typeCode = :typeCode 
  AND HearingUserRole.hearingID = :hearingID 
  AND CaseUserRole.recordStatus = :recordStatus