SELECT
CaseParticipantRoleNote.caseParticipantRoleNoteID,
CaseParticipantRoleNote.caseParticipantRoleID,
CaseParticipantRoleNote.recordStatus,
Note.sensitivityCode,
Note.notesText,
Note.userName,
Note.creationDateTime,
Note.priorityCode,
Users.fullName,
CaseParticipantRoleNote.noteID,
CaseParticipantRoleNote.versionNo
INTO
:caseParticipantRoleNoteID,
:caseParticipantRoleID,
:recordStatus,
:sensitivityCode,
:notesText,
:userName,
:creationDateTime,
:priorityCode,
:fullname,
:noteID,
:versionNo
FROM
Note,
CaseParticipantRoleNote,
Users
WHERE CaseParticipantRoleNote.caseParticipantRoleNoteID = :caseParticipantRoleNoteID
AND Note.noteID = CaseParticipantRoleNote.noteID
AND Note.userName = Users.userName
|