DBA Data[Home] [Help]

APPS.CN_SYS_TABLES_PVT dependencies on ALL_OBJECTS

Line 18: FROM all_objects

14: AND username = p_table_rec.schema;
15:
16: CURSOR l_table_csr IS
17: SELECT object_name
18: FROM all_objects
19: WHERE owner = p_table_rec.schema
20: AND object_type IN ('TABLE','VIEW')
21: AND object_name NOT IN
22: ( select name from cn_obj_tables_v )