SELECT DISTINCT
       o.name,
       o.type_desc,
       m.definition
  FROM sys.sql_modules m
       INNER JOIN
       sys.objects o
         ON m.object_id = o.object_id
 WHERE UPPER(m.definition) Like '%PVIDABG%';