Operation Details
Description: Method to read most current Note details for specified Link ID.
Sterotype: ns
SQL 
SELECT
  NoteLink.noteID
INTO
  :noteID 
FROM
  NoteLink,
  Note 
WHERE NoteLink.linkID = :linkID 
  AND NoteLink.noteID = Note.noteID 
  AND Note.creationDateTime = 
  ( 
  SELECT
    MAX(creationDateTime) 
  FROM
    NoteLink,
    Note 
  WHERE NoteLink.linkID = :linkID 
    AND NoteLink.noteID = Note.noteID 
  )