APPS.FEM_REFRESH_ENG_PKG dependencies on FEM_TABLES_B

Line 754: FROM fem_tables_b) R1,

750: FROM ( SELECT table_owner_application_id
751: FROM fem_rfsh_tables
752: UNION
753: SELECT table_owner_application_id
754: FROM fem_tables_b) R1,
755: fnd_application A1
756: WHERE R1.table_owner_application_id = A1.application_id;
757:
758: cursor c_tables (p_app_id IN NUMBER,p_schema IN VARCHAR2) IS

Line 769: FROM fem_tables_b T

765: WHERE A2.table_name = R.table_name
766: AND A2.owner = p_schema)
767: UNION
768: SELECT T.table_name
769: FROM fem_tables_b T
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