Check out example codes for "plsql find location of procedure". It will help you in understanding the concepts better.

Code Example 1

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

Learn ReactJs, React Native from akashmittal.com