DBA Data[Home] [Help]

APPS.BSC_COMMON_DIMENSIONS_PUB dependencies on BSC_TAB_INDICATORS

Line 170: FROM bsc_tab_indicators ti

166: CURSOR c_tab_kpis IS
167: SELECT DISTINCT kpi_measure_id, indicator
168: FROM bsc_kpi_analysis_measures_b
169: WHERE indicator IN (SELECT DISTINCT ti.indicator
170: FROM bsc_tab_indicators ti
171: WHERE ti.tab_id = p_tab_id);
172:
173: l_new_dim_obj_recs BSC_UTILITY.varchar_tabletype;
174: l_new_dim_obj_cnt NUMBER;

Line 361: FROM bsc_tab_indicators ti

357:
358: --CURSOR for all indicators in a tab
359: CURSOR c_inds IS
360: SELECT DISTINCT ti.indicator
361: FROM bsc_tab_indicators ti
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

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