SELECT
  caseID,
  concernRoleID,
  concernCaseRoleID
INTO
  :caseID,
  :concernRoleID,
  :concernCaseRoleID 
FROM
  ConcernCaseRole 
WHERE caseID = :caseID 
  AND concernRoleID = :concernRoleID 
  AND recordStatus = :recordStatus 
  AND 
  (
    
    (
      endDate >= :startDate 
      OR endDate IS NULL 
    ) 
    AND 
    (
      startDate <= :endDate 
      OR :endDate IS NULL 
    ) 
  )