APPS.BSC_UPDATE_LOCK dependencies on BSC_KPI_DATA_TABLES

Line 221: from bsc_kpi_data_tables

217: h_i NUMBER;
218:
219: CURSOR c_sum_tables IS
220: select distinct table_name
221: from bsc_kpi_data_tables
222: where indicator = x_indicator and table_name is not null;
223:
224: h_table_name VARCHAR2(50);
225:

Line 996: from bsc_kpi_data_tables

992: h_i NUMBER;
993:
994: CURSOR c_indicators IS
995: select distinct indicator
996: from bsc_kpi_data_tables
997: where table_name = x_table_name;
998:
999: h_indicator NUMBER;
1000:

Line 1196: from bsc_kpi_data_tables

1192: select distinct table_name
1193: from bsc_db_tables_rels
1194: start with table_name in (
1195: select distinct table_name
1196: from bsc_kpi_data_tables
1197: where indicator = x_indicator and
1198: table_name is not null
1199: )
1200: connect by table_name = prior source_table_name;