Operation Details |
Description: | Read Product Rules Link by Product and Date. |
Sterotype: | nsmulti |
SQL |
SELECT productRulesLinkID, ruleSetID, productID, startDate, endDate, comments, statusCode, versionNo INTO :productRulesLinkID, :ruleSetID, :productID, :startDate, :endDate, :comments, :statusCode, :versionNo FROM ProductRulesLink WHERE productID = :productID AND ( startDate <= :dateOfCalculation AND endDate >= :dateOfCalculation ) |