APPS.BSC_DEFAULT_KEY_ITEM_PUB dependencies on BSC_KPI_DIM_LEVELS_B

Line 16: l_level_view_name BSC_KPI_DIM_LEVELS_B.level_view_name%TYPE;

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);
19: l_dim_obj_cnt NUMBER;
20: l_key_name VARCHAR2(1000);

Line 514: FROM bsc_kpi_dim_levels_b

510: END IF;
511: END IF;
512:
513: SELECT count(0) INTO l_count
514: FROM bsc_kpi_dim_levels_b
515: WHERE indicator = p_kpi_id
516: AND dim_set_id = l_dim_set_id
517: AND dim_level_index = l_dim_level_index;
518:

Line 527: UPDATE bsc_kpi_dim_levels_b

523: WHERE indicator = p_kpi_id
524: AND dim_set_id = l_dim_set_id
525: AND dim_level_id = l_dim_level_id;
526:
527: UPDATE bsc_kpi_dim_levels_b
528: SET default_key_value = l_def_key_id
529: WHERE indicator = p_kpi_id
530: AND dim_set_id = l_dim_set_id
531: AND dim_level_index = l_dim_level_index;