Operation Details
Description: Retrieves a list of Case Participant Role Notes.
Sterotype: nsmulti
SQL 
SELECT
  CaseParticipantRoleNote.caseParticipantRoleNoteID,
  CaseParticipantRoleNote.caseParticipantRoleID,
  CaseParticipantRoleNote.recordStatus,
  Note.sensitivityCode,
  Note.creationDateTime,
  Note.priorityCode,
  Users.fullName,
  Note.userName,
  Note.notesText,
  CaseParticipantRoleNote.versionNo,
  Note.noteID
INTO
  :caseParticipantRoleNoteID,
  :caseParticipantRoleID,
  :recordStatus,
  :sensitivityCode,
  :creationDateTime,
  :priorityCode,
  :fullname,
  :userName,
  :notesText,
  :versionNo,
  :noteID 
FROM
  Note,
  CaseParticipantRoleNote,
  Users 
WHERE CaseParticipantRoleNote.caseParticipantRoleID = :caseParticipantRoleID 
  AND Note.noteID = CaseParticipantRoleNote.noteID 
  AND Note.userName = Users.userName