APPS.BSC_COMMON_DIMENSIONS_PUB dependencies on BSC_SYS_DIM_LEVELS_B

Line 366: FROM bsc_tab_indicators ti, bsc_sys_dim_levels_b sd, bsc_kpi_dim_levels_b kd

362: WHERE ti.tab_id = p_tab_id;
363: --CURSOR for indicators that contain particular dim level
364: CURSOR c_inds_levels IS
365: SELECT DISTINCT ti.indicator
366: FROM bsc_tab_indicators ti, bsc_sys_dim_levels_b sd, bsc_kpi_dim_levels_b kd
367: WHERE ti.tab_id = p_tab_id AND sd.dim_level_id = p_dim_level_id AND
368: kd.indicator = ti.indicator AND kd.level_table_name = sd.level_table_name;
369:
370: BEGIN