Operation Details
Description: Retrieves a list of communication exceptions for the specified concern role.
Sterotype: nsmulti
SQL 
SELECT
  commExceptionID,
  typeCode,
  toDate,
  fromDate,
  reasonCode,
  status,
  versionNo
INTO
  :commExceptionID,
  :typeCode,
  :toDate,
  :fromDate,
  :reasonCode,
  :status,
  :versionNo 
FROM
  ConcernRoleCommException 
WHERE concernRoleID = :concernRoleID 
ORDER BY fromDate DESC,
  toDate DESC