APPS.FEM_REFRESH_ENG_PKG dependencies on ALL_TABLES

Line 764: (SELECT table_name FROM ALL_TABLES A2

760: (SELECT R.table_name
761: FROM fem_rfsh_tables R
762: WHERE table_owner_application_id = p_app_id
763: AND EXISTS
764: (SELECT table_name FROM ALL_TABLES A2
765: WHERE A2.table_name = R.table_name
766: AND A2.owner = p_schema)
767: UNION
768: SELECT T.table_name

Line 774: (SELECT table_name FROM ALL_TABLES A1

770: WHERE T.table_owner_application_id = p_app_id
771: AND T.table_name not in (select table_name
772: FROM fem_rfsh_tables R)) RT
773: WHERE EXISTS
774: (SELECT table_name FROM ALL_TABLES A1
775: WHERE A1.table_name = RT.table_name
776: AND A1.owner = p_schema);
777:
778: -- Exceptions

Line 1163: FROM fem_rfsh_tables R, all_tables A

1159: ,ORACLE_SCHEMA => v_target_schema);
1160:
1161: SELECT count(*)
1162: INTO v_table_count
1163: FROM fem_rfsh_tables R, all_tables A
1164: WHERE R.table_name = A.table_name
1165: AND R.table_owner_application_id = v_app_id
1166: AND A.owner = v_target_schema;
1167: