Operation Details
Description: Returns the earliest delivery pattern record for the Case Nominee.
Sterotype: ns
SQL 
SELECT
  CaseNomineeProdDelPattern.caseNomineeProdDelPatternID,
  CaseNomineeProdDelPattern.fromDate,
  CaseNomineeProdDelPattern.toDate,
  CaseNomineeProdDelPattern.productDeliveryPatternID,
  CaseNomineeProdDelPattern.caseNomineeID,
  CaseNomineeProdDelPattern.statusCode
INTO
  :caseNomineeProdDelPatternID,
  :fromDate,
  :toDate,
  :productDeliveryPatternID,
  :caseNomineeID,
  :statusCode 
FROM
  CaseNomineeProdDelPattern 
WHERE CaseNomineeProdDelPattern.caseNomineeID = :caseNomineeID 
  AND CaseNomineeProdDelPattern.statusCode = :statusCode 
  AND CaseNomineeProdDelPattern.fromDate = 
  ( 
  SELECT
    MIN(CaseNomineeProdDelPattern.fromDate) 
  FROM
    CaseNomineeProdDelPattern 
  WHERE CaseNomineeProdDelPattern.caseNomineeID = :caseNomineeID 
  )