SELECT
  Verification.verificationRequirementID,
  Verification.verificationID,
  Verification.VDIEDLinkID,
  Verification.verificationStatus
INTO
  :verificationRequirementID,
  :verificationID,
  :VDIEDLinkID,
  :verificationStatus
FROM
  Verification,
  VDIEDLink 
WHERE Verification.VDIEDLinkID = VDIEDLink.VDIEDLinkID
  AND Verification.verificationStatus <> :verificationStatus
  AND VDIEDLink.evidenceDescriptorID IN 
  ( 
  SELECT
    evidenceDescriptorID 
  FROM
    EvidenceDescriptor 
  WHERE participantID = :concernRoleID 
    AND caseID = :caseID 
    AND evidenceType = :evidenceType 
    AND statuscode <> :evidenceStatus
  )