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