Locate All Stored Procedures and Their Objects/SQL Tables

select distinct A.name as sproc_name, C.name as dep_obj_name, C.xtype as dep_xtype
from sysobjects A
inner join sysdepends SD on A.id=SD.id
inner join sysobjects C on SD.depid=C.id and C.xtype in ('S', 'U', 'P', 'FN')
where A.xtype = 'P'
and   C.xtype = 'U'
AND   A.Status > 0
order by A.name, C.name