Operation Details |
Description: | |
Sterotype: | nsmulti |
SQL |
SELECT verificationItemUtilizationID, mandatory INTO :verificationItemUtilizationID, :mandatory FROM VerificationItemUtilization WHERE verifiableDataItemID = :verifiableDataItemID AND ( verificationLevel >= :level OR mandatory = :mandatory ) AND fromDate <= :fromDate AND ( toDate IS NULL OR toDate >= :toDate ) AND recordStatus <> :recordStatus |