Operation Details
Description: Returns the decisions dates in between those specified for a product and a case exclusive of the two dates used to perform the search.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT caseEligibilityDatesID,
  decisionDate
INTO
  :caseEligibilityDatesID,
  :decisionDate 
FROM
  CaseEligibilityDates 
WHERE 
  (
    caseID = :caseID 
    OR productID = :productID 
  ) 
  AND decisionDate > :fromDate 
  AND decisionDate < :toDate 
ORDER BY decisionDate