Operation Details
Description: Provides the name and Id of case participant for a related ID. where related id may be hearing representativeID or hearing witness id.
Sterotype: ns
SQL 
SELECT
  CaseParticipantRoleLink.caseparticipantroleid,
  concernrole.concernrolename
INTO
  :caseParticipantRoleID,
  :name 
FROM
  concernrole,
  caseparticipantrole,
  CaseParticipantRoleLink 
WHERE CaseParticipantRoleLink.caseparticipantroleid =caseparticipantrole.caseparticipantroleid 
  AND caseparticipantrole.participantroleid =concernrole.concernroleid 
  AND CaseParticipantRoleLink.relatedID = :relatedID