Operation Details
Description: Retrieves the participant and sensitivity code, case id and sensitivity related to this case participant role note.
Sterotype: ns
SQL 
SELECT
  CaseParticipantRole.participantRoleID,
  CaseParticipantRole.caseID,
  CaseParticipantRoleNote.noteID
INTO
  :participantID,
  :caseID,
  :noteID 
FROM
  CaseParticipantRoleNote,
  CaseParticipantRole 
WHERE CaseParticipantRoleNote.caseParticipantRoleNoteID = :caseParticipantRoleNoteID 
  AND CaseParticipantRoleNote.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID