APPS.BSC_DEFAULT_KEY_ITEM_PUB dependencies on BSC_KPI_DIM_LEVELS_VL

Line 96: FROM bsc_kpi_dim_levels_vl

92: IF(l_score_list IS NOT NULL) THEN
93:
94: SELECT level_view_name
95: INTO l_level_view_name
96: FROM bsc_kpi_dim_levels_vl
97: WHERE indicator = p_kpi_id
98: AND dim_set_id = l_dim_set_id
99: AND dim_level_index = l_dim_level_index;
100:

Line 304: FROM bsc_kpi_dim_levels_vl a,

300: CURSOR c_dim_obj IS
301: SELECT a.dim_set_id,
302: a.dim_level_index,
303: b.dim_level_id
304: FROM bsc_kpi_dim_levels_vl a,
305: bsc_sys_dim_levels_b b
306: WHERE b.short_name =a.level_shortname
307: AND a.level_shortname =p_dim_obj_sht_name
308: AND a.indicator =p_indicator;