Operation Details
Description: Method to list all verifications by case ID and evidence descriptor ID
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.verificationLinkedID = :verificationLinkedID
AND VDIEDLink.evidenceDescriptorID = :evidenceDescriptorID
AND Verification.verificationRequirementID = VerificationRequirement.verificationRequirementID