Operation Details |
Description: | |
Sterotype: | nsmulti |
SQL |
SELECT determinationPackageVersionID, minAge, maxAge, productID, gender, flag INTO :determinationPackageVersionID, :minAge, :maxAge, :productID, :gender, :flag FROM DeterminationPackageVersion a WHERE determinationConfigID = :determinationConfigID AND a.fromDate < :fromDate AND ( a.toDate >= :toDate OR a.toDate IS NULL ) AND a.versionStatus = :versionStatus |