SELECT
  Verification.verificationID,
  VerificationRequirement.verificationRequirementID,
  Verification.verificationStatus
INTO
  :verificationID,
  :verificationRequirementID,
  :verificationStatus 
FROM
  Verification,
  VerificationRequirement 
WHERE Verification.VDIEDLinkID = :VDIEDLinkID 
  AND Verification.verificationRequirementID = VerificationRequirement.verificationRequirementID 
  AND VerificationRequirement.mandatory = :mandatory