Operation Details
Description: Method to list active Contact Log details for specified Link id and Link Type.
Sterotype: nsmulti
SQL 
SELECT
  ContactLog.contactLogID,
  ContactLog.contactLogType,
  ContactLog.startDateTime,
  ContactLog.endDateTime,
  ContactLog.purpose,
  ContactLog.location,
  ContactLog.method,
  ContactLog.versionNo
INTO
  :contactLogID,
  :contactLogType,
  :startDateTime,
  :endDateTime,
  :purpose,
  :location,
  :method,
  :versionNo
FROM
  ContactLog,
  ContactLogLink 
WHERE ContactLogLink.linkID = :linkID 
  AND ContactLogLink.linkType = :linkType 
  AND ContactLogLink.recordStatus = :recordStatus 
  AND ContactLog.contactLogID = ContactLogLink.contactLogID 
  AND ContactLog.recordStatus = :recordStatus 
ORDER BY startDateTime DESC