APPS.BSC_UPDATE_LOCK dependencies on BSC_DB_TABLES_RELS

Line 872: ' SELECT DISTINCT table_name FROM bsc_db_tables_rels'||

868:
869: -- Lock base tables used by the dimension or any of the child dimensions
870: h_sql := 'SELECT DISTINCT bt.table_name'||
871: ' FROM ('||
872: ' SELECT DISTINCT table_name FROM bsc_db_tables_rels'||
873: ' WHERE source_table_name IN ('||
874: ' SELECT table_name FROM bsc_db_tables WHERE table_type = :1)) bt,'||
875: ' bsc_db_tables_cols c'||
876: ' WHERE bt.table_name = c.table_name AND'||

Line 1193: from bsc_db_tables_rels

1189: h_i NUMBER;
1190:
1191: CURSOR c_indic_tables IS
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

Line 1256: from bsc_db_tables_rels

1252: h_i NUMBER;
1253:
1254: CURSOR c_source_tables IS
1255: select distinct source_table_name
1256: from bsc_db_tables_rels
1257: where table_name = x_summary_table;
1258:
1259: h_table_name VARCHAR2(50);
1260:

Line 1318: from bsc_db_tables_rels

1314: where table_name like p_like_name;
1315:
1316: CURSOR c_source_tables (p_like_name varchar2) IS
1317: select distinct source_table_name
1318: from bsc_db_tables_rels
1319: where table_name like p_like_name;
1320:
1321: h_table_name VARCHAR2(50);
1322: h_like_name VARCHAR2(50);

Line 1402: from bsc_db_tables_rels

1398: h_i NUMBER;
1399:
1400: CURSOR c_source_tables IS
1401: select distinct source_table_name
1402: from bsc_db_tables_rels
1403: where table_name = x_summary_table;
1404:
1405: h_table_name VARCHAR2(50);
1406: