Operation Details
Description: This method is very similar to readNearestProdDelPatInfo except that this method returns the product delivery pattern info record that is in the future and is nearest to the input date.
Sterotype: ns
SQL 
SELECT
  productDeliveryPatternInfoID,
  productDeliveryPatternID,
  deliveryMethodID,
  name,
  nameTextID,
  maximumAmount,
  deliveryFrequency,
  coverPattern,
  offset,
  fromDate,
  recordStatus,
  comments
INTO
  :productDeliveryPatternInfoID,
  :productDeliveryPatternID,
  :deliveryMethodID,
  :name,
  :nameTextID,
  :maximumAmount,
  :deliveryFrequency,
  :coverPattern,
  :offset,
  :fromDate,
  :recordStatus,
  :comments 
FROM
  ProductDeliveryPatternInfo 
WHERE 
  (
    :productDeliveryPatternID = productDeliveryPatternID 
  ) 
  AND 
  (
    :recordStatus = recordStatus 
  ) 
  AND 
  (
    fromDate = 
    ( 
    SELECT
      MIN(fromDate) 
    FROM
      ProductDeliveryPatternInfo 
    WHERE 
      (
        :productDeliveryPatternID = productDeliveryPatternID 
      ) 
      AND 
      (
        :recordStatus = recordStatus 
      ) 
      AND 
      (
        fromDate > :effectiveDate 
      ) 
    ) 
  )