Operation Details
Description: Returns the hearingID, caseUserRoleID and userName parameters for a given hearingUserRoleID
Sterotype: ns
SQL 
SELECT
  HearingUserRole.caseUserRoleID,
  hearingID,
  orgObjectLinkID
INTO
  :caseUserRoleID,
  :hearingID,
  :orgObjectLinkID 
FROM
  HearingUserRole,
  CaseUserRole 
WHERE hearingUserRoleID = :hearingUserRoleID 
  AND HearingUserRole.caseUserRoleID = CaseUserRole.caseUserRoleID