SELECT
  Verification.verificationID,
  Verification.verificationRequirementID,
  Verification.VDIEDLinkID,
  Verification.verificationStatus
INTO
  :verificationID,
  :verificationRequirementID,
  :VDIEDLinkID,
  :verificationStatus
FROM
  VerificationRequirement,
  Verification,
  EvidenceDescriptor,
  VDIEDLink 
WHERE VerificationRequirement.verifiableDataItemID = 
  ( 
  SELECT
    VDIEDLink.verifiableDataItemID 
  FROM
    VDIEDLink 
  WHERE VDIEDLink.VDIEDLinkID = :VDIEDLinkID 
  ) 
  AND Verification.verificationRequirementID = VerificationRequirement.verificationRequirementID 
  AND Verification.verificationLinkedType <> :verificationLinkedType 
  AND Verification.verificationStatus <> :verificationStatus
  AND Verification.VDIEDLinkID = VDIEDLink.VDIEDLinkID
  AND VDIEDLink.evidenceDescriptorID = EvidenceDescriptor.evidenceDescriptorID 
  AND EvidenceDescriptor.participantID = :participantRoleID