Operation Details
Description: Searches for a communication type with a future end date/ no end date
Sterotype: nsmulti
SQL 
SELECT
  concernRoleID,
  status,
  typeCode,
  comments,
  fromDate,
  toDate
INTO
  :concernRoleID,
  :status,
  :typeCode,
  :comments,
  :fromDate,
  :toDate 
FROM
  ConcernRoleCommException 
WHERE ConcernRoleCommException.concernRoleID = :concernRoleID 
  AND ConcernRoleCommException.typeCode = :typeCode 
  AND ConcernRoleCommException.status = :status 
  AND 
  (
    ConcernRoleCommException.toDate IS NULL 
    OR ConcernRoleCommException.toDate >= :currentDate 
  ) 
  AND ConcernRoleCommException.fromDate <= :currentDate