Operation Details
Description: <p> Lists the User Hearing Officials associated with the hearing. </p>
Sterotype: nsmulti
SQL 
SELECT DISTINCT
Users.fullName,
Users.username

INTO
:hearingOfficialFullName,
:hearingOfficialUserName

FROM
Hearing,
CaseUserRole,
OrgObjectLink,
Users

WHERE
Hearing.hearingID = :hearingID AND
CaseUserRole.caseID = Hearing.caseID AND
CaseUserRole.typeCode = :hearingOfficialRoleType AND
OrgObjectLink.orgObjectLinkID = CaseUserRole.orgObjectLinkID AND
OrgObjectLink.userName = Users.userName AND
CaseUserRole.recordStatus = :normalRecordStatus