• If you do not use dynamic sql in your sp, you have the sysdepends table with all dependencies between objects.

    Here you are:

    SELECT object_name(id) as sp,object_name(depid) as dep_obj FROM sysdepends

    WHERE object_name(id) = 'mysp_elab'