SELECT
ParticipantNote.participantNoteID,
ParticipantNote.participantID,
ParticipantNote.recordStatus,
Note.sensitivityCode,
Note.notesText,
Note.creationDateTime,
Note.priorityCode,
Users.fullName,
Note.userName,
ParticipantNote.noteID,
ParticipantNote.versionNo
INTO
:participantNoteID,
:participantID,
:recordStatus,
:sensitivityCode,
:notesText,
:creationDateTime,
:priorityCode,
:fullname,
:userName,
:noteID,
:versionNo
FROM
Note,
ParticipantNote,
Users
WHERE ParticipantNote.participantNoteID = :participantNoteID
AND Note.noteID = ParticipantNote.noteID
AND Note.userName = Users.userName
|