System Tables Views Oracle PLSQL

SQL>
SQL> create table t ( x int );
Table created.
SQL>
SQL> create or replace view v as select * from t;
View created.
SQL>
SQL> create or replace procedure p
  2  as
  3  begin
  4          for x in ( select * from t )
  5          loop
  6                  null;
  7          end loop;
  8  end;
  9  /
SQL>
SQL> create or replace function f return number
  2  as
  3          countValue number;
  4  begin
  5          select count(*) into countValue from t;
  6          return countValue;
  7  end;
  8  /
Function created.
SQL>
SQL>
SQL> create or replace procedure p2
  2  as
  3  begin
  4          p;
  5  end;
  6  /
Warning: Procedure created with compilation errors.
SQL>
SQL>
SQL> select name, type, referenced_name, referenced_type
  2    from user_dependencies
  3   where referenced_owner = user  and rownum < 20
  4   order by name
  5  /
NAME                           TYPE
------------------------------ -----------------
REFERENCED_NAME
----------------------------------------------------------------
REFERENCED_TYPE
-----------------
COMPILEERROR                   PROCEDURE
DUAL
NON-EXISTENT
COMPILE_ERROR                  PROCEDURE
DUAL
NON-EXISTENT
NAME                           TYPE
------------------------------ -----------------
REFERENCED_NAME
----------------------------------------------------------------
REFERENCED_TYPE
-----------------
DEFINER_RIGHTS                 PACKAGE BODY
DUAL
NON-EXISTENT
LOOPING_EXAMPLE                PROCEDURE
DBMS_OUTPUT
NAME                           TYPE
------------------------------ -----------------
REFERENCED_NAME
----------------------------------------------------------------
REFERENCED_TYPE
-----------------
NON-EXISTENT
MONTH_GENERATOR                FUNCTION
SQLMONTH_TABLETYPE
TYPE
MONTH_GENERATOR_PIPED          FUNCTION
NAME                           TYPE
------------------------------ -----------------
REFERENCED_NAME
----------------------------------------------------------------
REFERENCED_TYPE
-----------------
SQLMONTH_TABLETYPE
TYPE
ORD_GENERATOR                  FUNCTION
ORD_TYPE
TYPE
NAME                           TYPE
------------------------------ -----------------
REFERENCED_NAME
----------------------------------------------------------------
REFERENCED_TYPE
-----------------
ORD_GENERATOR                  FUNCTION
ORD_TABLE
TYPE
ORD_GENERATOR_PIPED            FUNCTION
ORD_TABLE
TYPE
NAME                           TYPE
------------------------------ -----------------
REFERENCED_NAME
----------------------------------------------------------------
REFERENCED_TYPE
-----------------
ORD_GENERATOR_PIPED            FUNCTION
ORD_TYPE
TYPE
ORD_TABLE                      TYPE
ORD_TYPE
NAME                           TYPE
------------------------------ -----------------
REFERENCED_NAME
----------------------------------------------------------------
REFERENCED_TYPE
-----------------
TYPE
PRODUCT_PACKAGE                PACKAGE BODY
PRODUCT_PACKAGE
PACKAGE
P_ADD_ORDERS                   PROCEDURE
NAME                           TYPE
------------------------------ -----------------
REFERENCED_NAME
----------------------------------------------------------------
REFERENCED_TYPE
-----------------
DUAL
NON-EXISTENT
P_ADD_ORDERS                   PROCEDURE
ORDER_SEQ
NON-EXISTENT
NAME                           TYPE
------------------------------ -----------------
REFERENCED_NAME
----------------------------------------------------------------
REFERENCED_TYPE
-----------------
P_ADD_ORDERS                   PROCEDURE
P_ADD_ITEMS
PROCEDURE
P_ADD_PROD                     PROCEDURE
PRODUCT_SEQ
NON-EXISTENT
NAME                           TYPE
------------------------------ -----------------
REFERENCED_NAME
----------------------------------------------------------------
REFERENCED_TYPE
-----------------
READCLOB                       PROCEDURE
DBMS_OUTPUT
NON-EXISTENT
TEMPERATURE_CONVERSION         PROCEDURE
DBMS_OUTPUT
NAME                           TYPE
------------------------------ -----------------
REFERENCED_NAME
----------------------------------------------------------------
REFERENCED_TYPE
-----------------
NON-EXISTENT
USE_G2                         FUNCTION
DUAL
NON-EXISTENT
19 rows selected.
SQL>
SQL> drop table t;
Table dropped.