Operation Details
Description: Search for all of the active hearing user role records for the specified hearingID and user role type.
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