APPS.BSC_BIS_DIMENSION_PUB dependencies on BSC_KPIS_VL

Line 3220: FROM BSC_KPIS_VL

3216: , p_Dim_Set_Id => l_dim_set_id
3217: );
3218: IF(l_indp_dimobj >bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN
3219: SELECT NAME INTO l_kpi_name
3220: FROM BSC_KPIS_VL
3221: WHERE INDICATOR = l_kpi_id;
3222:
3223: IF(l_affected_kpis IS NULL) THEN
3224: l_affected_kpis := '['||l_kpi_name||']';

Line 3811: l_obj_name bsc_kpis_vl.name%TYPE;

3807: l_kpi_names VARCHAR2(32000);
3808: l_Dim_Grp_Id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;
3809: l_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
3810: l_indicator_list VARCHAR2(32000);
3811: l_obj_name bsc_kpis_vl.name%TYPE;
3812: l_ind bsc_kpis_vl.indicator%TYPE;
3813: l_sql VARCHAR2(2000);
3814: l_is_color_change NUMBER;
3815:

Line 3812: l_ind bsc_kpis_vl.indicator%TYPE;

3808: l_Dim_Grp_Id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;
3809: l_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
3810: l_indicator_list VARCHAR2(32000);
3811: l_obj_name bsc_kpis_vl.name%TYPE;
3812: l_ind bsc_kpis_vl.indicator%TYPE;
3813: l_sql VARCHAR2(2000);
3814: l_is_color_change NUMBER;
3815:
3816: CURSOR c_default_Value IS

Line 3892: l_sql := 'SELECT name, indicator FROM bsc_kpis_vl WHERE indicator IN (' || l_indicator_list || ') AND prototype_flag = 0 AND source_indicator IS NULL';

3888: IF(ref_cur%ISOPEN) THEN
3889: CLOSE ref_cur;
3890: END IF;
3891:
3892: l_sql := 'SELECT name, indicator FROM bsc_kpis_vl WHERE indicator IN (' || l_indicator_list || ') AND prototype_flag = 0 AND source_indicator IS NULL';
3893:
3894: OPEN ref_cur FOR l_sql;
3895: LOOP
3896: FETCH ref_cur INTO l_obj_name, l_ind;

Line 4005: , BSC_KPIS_VL B

4001:
4002: CURSOR c_dim_set_kpi IS
4003: SELECT DISTINCT B.Name||'['||B.Indicator||']' INDICATOR
4004: FROM BSC_KPI_DIM_GROUPS A
4005: , BSC_KPIS_VL B
4006: , BSC_SYS_DIM_GROUPS_VL C
4007: WHERE A.INDICATOR = B.INDICATOR
4008: AND B.share_flag <> 2
4009: AND A.Dim_Group_Id = C.Dim_Group_Id