I realise this is an old post, but I came across it when trying to look for a way to find dependencies within dynamic SQL. One thing I saw suggested on this stackoverflow post was a the free SQL Search tool from RedGate.

I think when used in conjunction with the DMVs listed above, it can certainly help you find your dependencies.