Operation Details
Description: Searches for all the verification item names which are applicable for the current date
Sterotype: nsmulti
SQL 
SELECT
  vu.verificationItemUtilizationID,
  vi.name
INTO
  :verificationItemUtilizationID,
  :name 
FROM
  VerificationItemUtilization vu,
  VerificationItem vi 
WHERE vu.verifiableDataItemID = :verifiableDataItemID 
  AND vu.verificationItemID = vi.verificationItemID 
  AND vu.fromDate <= :currentDate 
  AND 
  (
    vu.toDate IS NULL 
    OR vu.toDate >= :currentDate 
  )
   AND ( vu.verificationGroupID  IS NULL)