Operation Details
Description: Returns multiple user details based on a hearingUserRoleID.
Sterotype: ns
SQL 
SELECT
  participatedCode,
  CaseUserRole.orgObjectLinkID,
  recordStatus,
  typeCode,
  CaseUserRole.versionNo,
  HearingUserRole.versionNo
INTO
  :participatedCode,
  :orgObjectLinkID,
  :recordStatus,
  :typeCode,
  :versionNo,
  :hearingUserRoleVersionNo 
FROM
  HearingUserRole,
  CaseUserRole 
WHERE hearingUserRoleID = :hearingUserRoleID 
  AND CaseUserRole.caseUserRoleID = HearingUserRole.caseUserRoleID