SELECT
VerificationItemUtilization.verificationItemUtilizationID,
VerificationItemUtilization.verificationItemID,
VerificationItemUtilization.verifiableDataItemID,
VerificationItemUtilization.verificationLevel,
VerificationItemUtilization.fromDate,
VerificationItemUtilization.toDate,
VerificationItem.name
INTO
:verificationItemUtilizationID,
:verificationItemID,
:verifiableDataItemID,
:verificationLevel,
:fromDate,
:toDate,
:name
FROM
VerificationItemUtilization,
VerificationItem
WHERE VerificationItemUtilization.verifiableDataItemID = :verifiableDataItemID
AND VerificationItemUtilization.recordStatus <> :recordStatus
AND ( VerificationItemUtilization.verificationGroupID IS NULL)
|