Operation Details
Description:  
Sterotype: nsmulti
SQL 
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, VerificationRequirement 
WHERE 
Verification.VDIEDLinkID = VDIEDLink.VDIEDLinkID  
AND Verification.verificationStatus = 'VST2' 
AND Verification.verificationLinkedID = :verificationLinkedID
AND VDIEDLink.evidenceDescriptorID = :evidenceDescriptorID
AND Verification.verificationRequirementID = VerificationRequirement.verificationRequirementID
AND VerificationRequirement.mandatory = '1'