SELECT
Verification.verificationID,
Verification.verificationRequirementID,
Verification.VDIEDLinkID,
Verification.verificationLinkedID,
Verification.verificationLinkedType,
Verification.dueDate,
Verification.verificationStatus
INTO
:verificationID,
:verificationRequirementID,
:VDIEDLinkID,
:verificationLinkedID,
:verificationLinkedType,
:dueDate,
:verificationStatus
FROM Verification, VDIEDLink
WHERE Verification.VDIEDLinkID = VDIEDLink.VDIEDLinkID
AND VDIEDLINK.evidenceDescriptorID = :evidenceDescriptorID
AND verificationStatus=:verificationStatus
|