Operation Details |
Description: | This methods reads the verification utilization details by verification level and from date. |
Sterotype: | nsmulti |
SQL |
SELECT verificationItemUtilizationID, expiryDays, warningDays, expiryDateFrom INTO :verificationItemUtilizationID, :expiryDays, :warningDays, :expiryDateFrom FROM VerificationItemUtilization viu WHERE viu.verificationLevel = :level AND viu.fromDate <= :fromDate |