Operation Details
Description: This method returns a list of active Communication Exceptions as at a particular date.
Sterotype: nsmulti
SQL 
SELECT
  concernRoleID,
  status,
  typeCode,
  reasonCode,
  comments,
  fromDate,
  toDate
INTO
  :concernRoleID,
  :status,
  :typeCode,
  :reasonCode,
  :comments,
  :fromDate,
  :toDate 
FROM
  ConcernRoleCommException 
WHERE ConcernRoleCommException.concernRoleID = :concernRoleID 
  AND status = :status 
  AND 
  (
    ConcernRoleCommException.toDate IS NULL 
    OR ConcernRoleCommException.toDate >= :currentDate 
  ) 
  AND ConcernRoleCommException.fromDate <= :currentDate