Plsql find location of procedure

SELECT * 
FROM SYS.DBA_DEPENDENCIES 
WHERE  REFERENCED_NAME = '<NAME_OF_PKG_OR_PROC_FUNC>' AND 
REFERENCED_TYPE IN ('PACKAGE', 'PROCEDURE', 'FUNCTION');

Similar codes

0 vote164 views1 answer
Mysql collation portugues brasil
SQL
5 votes111 views1 answer
Sql select ciunt
SQL
0 vote125 views1 answer
Mssql disable foreign key constraint
SQL
1 vote118 views4 answers
Postgres extract date from timestamp
SQL
1 vote119 views1 answer
Mysql select utc time in eastern time
SQL
4 votes124 views2 answers
REST API
SQL
0 vote122 views1 answer
How to query without duplicate rows in sql
SQL
2 votes139 views1 answer
Revokeprivileges mysql
SQL
0 vote124 views1 answer
How to put is null in where in clause
SQL
0 vote145 views1 answer
Mysql date without time
SQL