| Operation Details |  |
| Description: | Return all users of a particular status for a hearing. |
| Sterotype: | nsmulti |
| SQL | |
SELECT HearingUserRole.caseUserRoleID INTO :caseUserRoleID FROM HearingUserRole, CaseUserRole WHERE HearingUserRole.caseUserRoleID = CaseUserRole.caseUserRoleID AND HearingUserRole.hearingID = :hearingID AND CaseUserRole.recordStatus = :recordStatus |