Is there any application which can tell you the procedure called within a procedure.
Once upon a long ago I wrote a query that approximated this... It worked reasonably well as long as the SQL Server system tables (specifically the ones that track object dependance) were kept up to date, and the code did not use dynamic SQL.
The problem is that dependancies are slippery things... They tend to be difficult to track, so the system tables would slowly slip out of completeness (due to object co-dependancy, etc), and more and more dynamic code would creep in, making the queries less useful.
As long as you can avoid co-depdenancy (where two or more SQL objects depend on each other), and have no dynamic code, this might be possible using system tables. With a sufficiently sophisticated Transact-SQL parser, you can probably resolve co-dependancies and detect dynamic SQL.
I'm not sure that you can completely solve this problem.