Operation Details |
Description: | Returns all users, regardless of their status, including versionNo, for a hearing. |
Sterotype: | nsmulti |
SQL |
SELECT CaseUserRole.orgObjectLinkID, recordStatus, participatedCode, typeCode, hearingUserRoleID, HearingUserRole.versionNo INTO :orgObjectLinkID, :recordStatus, :participatedCode, :typeCode, :hearingUserRoleID, :versionNoOpt FROM HearingUserRole, CaseUserRole WHERE hearingID = :hearingID AND CaseUserRole.caseUserRoleID = HearingUserRole.caseUserRoleID |