Operation Details |
Description: | Reads details, including versionNo, about all users of the specified type for the 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 AND typeCode = :typeCode |