SELECT
  DISTINCT(vi.name)
INTO
  :name 
FROM
  VerificationItem vi,
  VerificationItemUtilization viu,
  VerificationItemProvided vip,
  VerificationAttachmentLink val 
WHERE val.verificationItemProvidedID = :verificationItemProvidedID 
  AND val.verificationItemProvidedID = vip.verificationItemProvidedID 
  AND vip.verificationItemUtilizationID = viu.verificationItemUtilizationID 
  AND viu.verificationItemID = vi.verificationItemID