Operation Details
Description: Returns the delivery frequency history record for a product on a given date.
Sterotype: ns
SQL 
SELECT
  prodDeliveryFreqHistoryID,
  productID,
  startDate,
  endDate,
  deliveryFrequency
INTO
  :prodDeliveryFreqHistoryID,
  :productID,
  :startDate,
  :endDate,
  :deliveryFrequency 
FROM
  ProductDeliveryFrequencyHist 
WHERE ProductDeliveryFrequencyHist.productID = :productID 
  AND 
  (
    ProductDeliveryFrequencyHist.startDate <= :effectiveDate 
  ) 
  AND 
  (
    ProductDeliveryFrequencyHist.endDate > :effectiveDate 
    OR ProductDeliveryFrequencyHist.endDate IS NULL 
  )