Operation Details
Description: Returns the next decision date for a case whether it is associated with the case of a product.
Sterotype: ns
SQL 
SELECT
  caseEligibilityDatesID,
  decisionDate
INTO
  :caseEligibilityDatesID,
  :decisionDate 
FROM
  CaseEligibilityDates c 
WHERE 
  (
    c.caseID = :caseID 
    OR c.productID = :productID 
  ) 
  AND c.decisionDate = ( 
  SELECT
    MIN(decisionDate) 
  FROM
    CaseEligibilityDates c 
  WHERE 
    (
      c.caseID = :caseID 
      OR c.productID = :productID 
    ) 
    AND c.decisionDate >= :fromDate 
  )