APPS.BSC_UPDATE_UTIL dependencies on BSC_DB_TABLES_RELS

Line 3223: FROM bsc_kpi_data_tables t, bsc_db_tables_rels r, bsc_kpis_b k

3219: ) RETURN NUMBER IS
3220:
3221: CURSOR c_kpis IS
3222: SELECT DISTINCT k.indicator, k.prototype_flag
3223: FROM bsc_kpi_data_tables t, bsc_db_tables_rels r, bsc_kpis_b k
3224: WHERE t.table_name = r.table_name AND
3225: t.indicator = k.indicator AND
3226: (t.table_name = x_table_name OR
3227: (r.source_table_name = x_table_name AND r.relation_type = 1));

Line 3594: FROM bsc_db_tables t, bsc_db_tables_rels r

3590: ) RETURN BOOLEAN IS
3591:
3592: CURSOR c_table_type IS
3593: SELECT t.table_type
3594: FROM bsc_db_tables t, bsc_db_tables_rels r
3595: WHERE t.table_name = r.source_table_name and
3596: r.table_name = x_table_name;
3597:
3598: h_table_type NUMBER;

Line 6095: from bsc_db_tables_rels

6091: select count(table_name)
6092: into h_count
6093: from (
6094: select distinct table_name
6095: from bsc_db_tables_rels
6096: start with table_name in (
6097: select distinct kd.table_name
6098: from bsc_kpi_data_tables kd, bsc_kpi_properties k
6099: where k.indicator = kd.indicator and