APPS.BSC_DEFAULT_KEY_ITEM_PUB dependencies on BSC_SYS_DIM_LEVELS_B

Line 13: l_dim_level_id BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE;

9: , x_msg_count OUT NOCOPY NUMBER
10: , x_msg_data OUT NOCOPY VARCHAR2
11: )IS
12:
13: l_dim_level_id BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE;
14: l_dim_level_val BSC_SYS_FILTERS.dim_level_value%TYPE;
15: l_score_list VARCHAR2(30000);
16: l_level_view_name BSC_KPI_DIM_LEVELS_B.level_view_name%TYPE;
17: l_dim_obj_recs BSC_UTILITY.varchar_tabletype;

Line 305: bsc_sys_dim_levels_b b

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;
309: