Operation Details |
Description: | Returns all the decision dates for a product and a case. |
Sterotype: | nsmulti |
SQL |
SELECT DISTINCT caseEligibilityDatesID, decisionDate INTO :caseEligibilityDatesID, :decisionDate FROM CaseEligibilityDates WHERE caseID = :caseID OR productID = :productID ORDER BY decisionDate |