Operation Details
Description: Method to count active Contact Log Link records for specified Link id, Link Type and Attendee Concern Role id which exist for other that specified Contact Log id.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :count 
FROM
  ContactLog,
  ContactLogLink,
  ContactLogAttendee 
WHERE ContactLogLink.linkID = :linkID 
  AND ContactLogLink.linkType = :linkType 
  AND ContactLogLink.contactLogID <> :contactLogID 
  AND ContactLogLink.recordStatus = :recordStatus 
  AND ContactLogLink.contactLogID = ContactLog.contactLogID 
  AND ContactLog.recordStatus = :recordStatus 
  AND ContactLogLink.contactLogID = ContactLogAttendee.contactLogID 
  AND ContactLogAttendee.concernRoleID = :concernRoleID 
  AND ContactLogAttendee.recordStatus = :recordStatus