Operation Details
Description: Returns the list of active attendee users together with their userName and display name for the hearing.
Sterotype: nsmulti
SQL 
SELECT
  HearingUserRole.hearingUserRoleID,
  CaseUserRole.caseUserRoleID,
  CaseUserRole.orgObjectLinkID,
  CaseUserRole.typeCode,
  HearingUserRole.versionNo,
  HearingUserRole.participatedCode
INTO
  :hearingUserRoleID,
  :caseUserRoleID,
  :orgObjectLinkID,
  :typeCode,
  :versionNo,
  :participatedCode 
FROM
  HearingUserRole,
  CaseUserRole 
WHERE HearingUserRole.caseUserRoleID = CaseUserRole.caseUserRoleID 
  AND HearingUserRole.hearingID = :hearingID 
  AND CaseUserRole.recordStatus = :recordStatus 
  AND NOT CaseUserRole.typeCode = :excludeTypeCode