APPS.EDW_DB_STATUS dependencies on EDW_SOURCE_INSTANCES_VL

Line 156: FROM edw_source_instances_vl

152: l_temp number := 0;
153:
154: CURSOR instances IS
155: SELECT instance_code, warehouse_to_instance_link
156: FROM edw_source_instances_vl
157: WHERE enabled_flag = 'Y';
158:
159: BEGIN
160:

Line 219: FROM edw_source_instances_vl

215: l_temp number := 0;
216:
217: CURSOR instances IS
218: SELECT instance_code, warehouse_to_instance_link
219: FROM edw_source_instances_vl
220: WHERE enabled_flag = 'Y'
221: AND instance_code=p_instance_code;
222:
223: BEGIN

Line 369: FROM edw_source_instances_vl

365: p_table_name in varchar2) return varchar2 IS
366:
367: CURSOR instances IS
368: SELECT instance_code, warehouse_to_instance_link
369: FROM edw_source_instances_vl
370: WHERE enabled_flag = 'Y';
371:
372: l_progress VARCHAR2(3) := '000';
373: l_db_link VARCHAR2(30);

Line 443: FROM edw_source_instances_vl

439: p_table_name in varchar2) return VARCHAR2 IS
440:
441: CURSOR instances IS
442: SELECT warehouse_to_instance_link
443: FROM edw_source_instances_vl
444: WHERE enabled_flag = 'Y'
445: AND instance_code=p_instance_code;
446:
447: l_progress VARCHAR2(3) := '000';