SELECT
  concernRoleID,
  commExceptionID,
  status,
  typeCode,
  comments,
  fromDate,
  toDate
INTO
  :concernRoleID,
  :commExceptionID,
  :status,
  :typeCode,
  :comments,
  :fromDate,
  :toDate 
FROM
  ConcernRoleCommException 
WHERE commExceptionID <> :commExceptionID 
  AND concernRoleID = :concernRoleID 
  AND typeCode = :typeCode 
  AND status = :status 
  AND 
  (
    
    (
      toDate >= :fromDate 
      OR toDate IS NULL 
    ) 
    AND 
    (
      fromDate <= :toDate 
      OR :toDate IS NULL 
    ) 
  )