APPS.BIS_VIEW_GENERATOR_PVT dependencies on ALL_TABLES

Line 2131: SELECT a.table_name INTO l_instance FROM all_tables a, user_synonyms u

2127: execute immediate 'ALTER session SET global_names=FALSE';
2128: SELECT db_link INTO l_instance from user_db_links where
2129: db_link like 'EDW_APPS_TO_WH%';
2130:
2131: SELECT a.table_name INTO l_instance FROM all_tables a, user_synonyms u
2132: WHERE a.table_name = 'EDW_LOCAL_GENERATION_STATUS'
2133: AND u.table_name= 'EDW_LOCAL_GENERATION_STATUS'
2134: AND a.owner = u.table_owner;
2135: l_warehouse_exists := 1;