SELECT
  citizenshipID,
  countryCode,
  statusCode,
  fromDate,
  toDate
INTO
  :citizenshipID,
  :countryCode,
  :statusCode,
  :fromDate,
  :toDate 
FROM
  Citizenship 
WHERE citizenshipID <> :citizenshipID 
  AND concernRoleID = :concernRoleID 
  AND statusCode = :statusCode 
  AND countryCode = :countryCode 
  AND 
  (
    
    (
      :toDate >= fromDate 
      OR :toDate IS NULL 
    ) 
    AND 
    (
      :fromDate <= toDate 
      OR toDate IS NULL 
    ) 
  )