SELECT
  productRulesLinkID,
  ruleSetID,
  productID,
  startDate,
  endDate,
  comments,
  statusCode,
  versionNo
INTO
  :productRulesLinkID,
  :ruleSetID,
  :productID,
  :startDate,
  :endDate,
  :comments,
  :statusCode,
  :versionNo 
FROM
  ProductRulesLink 
WHERE productID = :productID 
  AND 
  (
    startDate <= :dateOfCalculation 
    AND endDate >= :dateOfCalculation 
  )   AND statusCode <> :statusCode