SELECT
  investigationConfigID,
  type
INTO
  :investigationConfigID,
  :type 
FROM
  InvestigationConfig 
WHERE recordStatus = :recordStatus 
  AND startDate <= :date 
  AND 
  (
    endDate is null 
    OR endDate >= :date 
  )