Oracle Database Discussions

Hi -

I would like to find the following dependency relationships in the database:

1. Query to find :
- Packages being invoked from a particular package i..e if we give the package-name as the input - the query should give the names of all packages being called from within it.
- Packages that invoke the current package i.e. a list of packages which are invoking the current package.

2. Query to find the packages where a particular function / stored procedure is being used. Here we can provide the function name as the input parameter.

3. Query to find the packages where a particular table is being used. Here the input parameter would be the table name.

Please let me know how I can frame the above queries.

Regards -
Sandeep