SELECT
  estimatedCost,
  productProvisionID
INTO
  :estimateCost,
  :productProvisionID 
FROM
  ProductProvision 
WHERE productID = :productID 
  AND providerConcernRoleID = :providerConcernRoleID 
  AND statusCode = :statusCode 
  AND startDate <= :effectiveDate 
  AND 
  (
    endDate >= :effectiveDate 
    OR endDate IS NULL 
  )