DBA Data[Home] [Help]

APPS.FEM_TABLE_REGISTRATION_PKG dependencies on USER_OBJECTS

Line 2244: AND EXISTS (SELECT 1 FROM user_objects WHERE object_name = di_view_name

2240: x_di_view_name varchar2(30);
2241: BEGIN
2242: SELECT di_view_name INTO x_di_view_name FROM fem_tables_b
2243: WHERE table_name = p_table_name
2244: AND EXISTS (SELECT 1 FROM user_objects WHERE object_name = di_view_name
2245: AND status = 'VALID');
2246:
2247: RETURN x_di_view_name;
2248: