Operation Details
Description: Method to list active concern roles registered as Contact Log Attendee for specified Contact Log id.
Sterotype: nsmulti
SQL 
SELECT
  ContactLogAttendee.contactLogAttendeeID,
  ContactLogAttendee.concernRoleID,
  ConcernRole.concernRoleName,
  ContactLogAttendee.versionNo
INTO
  :contactLogAttendeeID,
  :concernRoleID,
  :concernRoleName,
  :versionNo 
FROM
  ContactLogAttendee,
  ConcernRole 
WHERE ContactLogAttendee.contactLogID = :contactLogID 
  AND ContactLogAttendee.recordStatus = :recordStatus 
  AND ContactLogAttendee.concernRoleID IS NOT NULL 
  AND ConcernRole.concernRoleID = ContactLogAttendee.concernRoleID