SELECT
ContactLog.contactLogID,
ContactLog.contactLogType,
ContactLog.startDateTime,
ContactLog.purpose,
ContactLog.location,
ContactLog.method,
ContactLog.addendumInd
INTO
:contactLogID,
:contactLogType,
:startDateTime,
:purpose,
:location,
:method,
:addendumInd
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
|