Operation Details
Description: Method to list active contact log concerning participants for a specified link id and link type.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT ContactLogConcern.concernRoleID,
  ConcernRole.concernRoleName
INTO
  :concernRoleID,
  :concernRoleName 
FROM
  ContactLog,
  ContactLogLink,
  ContactLogConcern,
  ConcernRole 
WHERE ContactLogLink.linkID = :linkID 
  AND ContactLogLink.linkType = :linkType 
  AND ContactLogLink.contactLogID = ContactLog.contactLogID 
  AND ContactLog.contactLogID = ContactLogConcern.contactLogID 
  AND ContactLogConcern.recordStatus = :recordStatus 
  AND ContactLogConcern.concernRoleID = ConcernRole.concernRoleID