Documenting where stored procs are called from
SQL Server has the sys.sql_dependencies table.

In SSMS you can right-click an object and choose "dependencies". My subjective experience is that this can be incomplete.

References from application code may be amenable to a simple search, depending on how it's constructed.