APPS.BIS_VIEW_GENERATOR_PVT dependencies on USER_DB_LINKS

Line 1849: SELECT db_link INTO l_instance from user_db_links where

1845: BEGIN
1846: execute immediate 'ALTER session SET global_names=FALSE';
1847: --- --- DEBUG
1848: --- dbms_output.put_line('GENERATE_PRUNED_VIEW - Checking Warehouse link');
1849: SELECT db_link INTO l_instance from user_db_links where
1850: db_link like 'EDW_APPS_TO_WH%';
1851:
1852:
1853: execute immediate 'SELECT instance_code FROM edw_local_instance'

Line 2128: SELECT db_link INTO l_instance from user_db_links where

2124: --- CHECK FOR WAREHOUSE PRESENCE
2125: BEGIN
2126:
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'