SELECT
  CaseParticipantRoleLink.caseParticipantRoleLinkID,
  CaseParticipantRoleLink.caseparticipantroleid,
  caseparticipantrole.participantroleid,
  concernrole.concernrolename,
  CaseParticipantRoleLink.versionno
INTO
  :caseParticipantRoleLinkID,
  :caseParticipantRoleID,
  :participantRoleID,
  :name,
  :versionNo 
FROM
  CaseParticipantRoleLink,
  caseparticipantrole,
  concernrole 
WHERE CaseParticipantRoleLink.CASEPARTICIPANTROLEID = caseparticipantrole.CASEPARTICIPANTROLEID 
  AND caseparticipantrole.PARTICIPANTROLEID =concernrole.CONCERNROLEID 
  AND CaseParticipantRoleLink.RELATEDID = :relatedID 
  AND CaseParticipantRoleLink.recordStatus = :recordStatus