SQL> create view v_e_teacherloginfo as select * from e_teacherlogininfo;
View created.
SQL> select name,type,referenced_owner,referenced_name,dependency_type from user_dependencies;
NAME TYPE REFERENCED_OWNER REFERENCED_NAME DEPE
-------------------------------------------------- -------------------- ------------------------------ ------------------------------ ----
PKG_E_TEACHERLOGININFO PACKAGE BODY SYS STANDARD HARD
PKG_E_TEACHERLOGININFO PACKAGE SYS STANDARD HARD
V_E_TEACHERLOGINFO VIEW PD E_TEACHERLOGININFO HARD
PKG_E_TEACHERLOGININFO PACKAGE BODY PD PKG_E_TEACHERLOGININFO HARD
-------------------------------------------------- -------------------- ------------------------------ ------------------------------ ----
PKG_E_TEACHERLOGININFO PACKAGE BODY SYS STANDARD HARD
PKG_E_TEACHERLOGININFO PACKAGE SYS STANDARD HARD
V_E_TEACHERLOGINFO VIEW PD E_TEACHERLOGININFO HARD
PKG_E_TEACHERLOGININFO PACKAGE BODY PD PKG_E_TEACHERLOGININFO HARD