SELECT
  fundedItemRulesLinkID,
  ruleSetID,
  relatedID,
  relatedType,
  startDate,
  endDate,
  creoleRuleSetID,
  ruleSetType,
  dataStoreSchema,
  recordStatus
INTO
  :fundedItemRulesLinkID,
  :ruleSetID,
  :relatedID,
  :relatedType,
  :startDate,
  :endDate,
  :creoleRuleSetID,
  :ruleSetType,
  :dataStoreSchema,
  :recordStatus 
FROM
  FundedItemRulesLink 
WHERE relatedID = :relatedID 
  AND relatedType = :relatedType 
  AND startDate <= :effectiveDate 
  AND 
  (
    endDate >= :effectiveDate 
    OR endDate IS NULL 
  ) 
  AND recordStatus = :recordStatus