APPS.BSC_DEFAULT_KEY_ITEM_PUB dependencies on BSC_SYS_FILTERS

Line 14: l_dim_level_val BSC_SYS_FILTERS.dim_level_value%TYPE;

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;
18: l_dim_obj_rec VARCHAR2(200);

Line 33: FROM bsc_sys_filters

29: a.tab_id,
30: b.name,
31: DECODE (
32: (SELECT COUNT(0)
33: FROM bsc_sys_filters
34: WHERE source_type =1
35: AND source_code =a.tab_id
36: AND dim_level_id =l_dim_level_id
37: ),0,1,

Line 39: FROM bsc_sys_filters

35: AND source_code =a.tab_id
36: AND dim_level_id =l_dim_level_id
37: ),0,1,
38: (SELECT COUNT(0)
39: FROM bsc_sys_filters
40: WHERE source_type =1
41: AND source_code =a.tab_id
42: AND dim_level_id =l_dim_level_id
43: AND dim_level_value =l_def_key_id)) total