APPS.EDW_SYSTEM_PARAMS_PKG dependencies on EDW_SOURCE_INSTANCES_VL

Line 7: FROM edw_source_instances_vl

3: l_db_link VARCHAR2(240);
4:
5: CURSOR instances IS
6: SELECT warehouse_to_instance_link
7: FROM edw_source_instances_vl
8: WHERE enabled_flag = 'Y';
9: CURSOR cols IS
10: SELECT column_name
11: FROM all_tab_columns

Line 17: FROM edw_source_instances_vl

13: AND owner=edw_owb_collection_util.get_db_user('BIS')
14: AND column_name NOT IN ('LAST_UPDATE_DATE', 'CREATION_DATE'); --removed Upper for bug#4905343
15: CURSOR sources IS
16: SELECT instance_code, warehouse_to_instance_link
17: FROM edw_source_instances_vl
18: WHERE enabled_flag = 'Y';
19:
20: Function isInstanceRunning(p_mode IN NUMBER, p_db_link IN VARCHAR2, p_instance IN VARCHAR2) RETURN BOOLEAN IS
21: cid NUMBER := 0;