SELECT DISTINCT o.name, o.type_desc, p.name, p.type_desc

FROM sys.sql_dependencies d

INNER JOIN sys.objects o

ON d.object_id = o.object_id

INNER JOIN sys.objects p

ON d.referenced_major_id = p.object_id

Worth a try from a quick google search