Operation Details
Description: Reads the next Case Nominee Product Delivery Pattern by case nominee, date and status.
Sterotype: ns
SQL 
SELECT
  caseNomineeProdDelPatternID,
  fromDate,
  toDate,
  productDeliveryPatternID,
  caseNomineeID,
  statusCode,
  versionNo
INTO
  :caseNomineeProdDelPatternID,
  :fromDate,
  :toDate,
  :productDeliveryPatternID,
  :caseNomineeID,
  :statusCode,
  :versionNo 
FROM
  CaseNomineeProdDelPattern 
WHERE caseNomineeID = :caseNomineeID 
  AND statusCode = :statusCode 
  AND fromDate = 
  ( 
  SELECT
    MIN(fromDate) 
  FROM
    CaseNomineeProdDelPattern 
  WHERE caseNomineeID = :caseNomineeID 
    AND statusCode = :statusCode 
    AND fromDate >= :effectiveDate 
  )