Operation Details
Description: Counts the number of currently active exceptions for a concern role.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :count 
FROM
  ConcernRoleCommException 
WHERE ConcernRoleCommException.concernRoleID = :concernRoleID 
  AND ConcernRoleCommException.status = :status 
  AND 
  (
    ConcernRoleCommException.toDate IS NULL 
    OR ConcernRoleCommException.toDate >= :currentDate 
  ) 
  AND ConcernRoleCommException.fromDate <= :currentDate