SELECT
  Verification.verificationID,
  Verification.verificationRequirementID
INTO
  :verificationID,
  :verificationRequirementID 
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.VDIEDLinkID = VDIEDLink.VDIEDLinkID 
  AND VDIEDLink.evidenceDescriptorID = EvidenceDescriptor.evidenceDescriptorID 
  AND EvidenceDescriptor.participantID = :participantRoleID