APPS.EDW_UPDATE_ATTRIBUTES dependencies on EDW_SOURCE_INSTANCES_VL

Line 391: FROM edw_source_instances_vl

387: l_dblink varchar2(100);
388: BEGIN
389:
390: SELECT warehouse_to_instance_link INTO l_dblink
391: FROM edw_source_instances_vl
392: WHERE instance_code = p_instance;
393: return l_dblink;
394: END;
395:

Line 534: from EDW_SOURCE_INSTANCES_VL

530:
531: BEGIN
532:
533: SELECT warehouse_to_instance_link into l_db_link
534: from EDW_SOURCE_INSTANCES_VL
535: WHERE instance_code = p_instance;
536:
537: stmt := 'select substr(RELEASE_NAME, 1,8) from fnd_product_groups@'|| l_db_link;
538: open cv for stmt;