APPS.BSC_COMMON_DIM_LEVELS_PUB dependencies on BSC_KPI_DIM_LEVELS_B

Line 717: UPDATE BSC_KPI_DIM_LEVELS_B SET DEFAULT_VALUE = 'T'

713: LOOP
714: FETCH c_KPIs INTO v_Indicator;
715: EXIT WHEN c_KPIs%NOTFOUND;
716:
717: UPDATE BSC_KPI_DIM_LEVELS_B SET DEFAULT_VALUE = 'T'
718: WHERE INDICATOR = v_Indicator AND DEFAULT_VALUE Like 'D%';
719:
720: for v_Index IN 1.. v_Common_Level_ReTrieved_Tbl.COUNT LOOP
721: v_Dim_Level_Rec_R := v_Common_Level_ReTrieved_Tbl(v_Index);

Line 722: UPDATE BSC_KPI_DIM_LEVELS_B SET DEFAULT_VALUE = 'D' || v_Dim_Level_Rec_R.Bsc_Level_Index

718: WHERE INDICATOR = v_Indicator AND DEFAULT_VALUE Like 'D%';
719:
720: for v_Index IN 1.. v_Common_Level_ReTrieved_Tbl.COUNT LOOP
721: v_Dim_Level_Rec_R := v_Common_Level_ReTrieved_Tbl(v_Index);
722: UPDATE BSC_KPI_DIM_LEVELS_B SET DEFAULT_VALUE = 'D' || v_Dim_Level_Rec_R.Bsc_Level_Index
723: WHERE INDICATOR = v_Indicator AND LEVEL_TABLE_NAME = v_Dim_Level_Rec_R.Bsc_Level_View_Name;
724:
725: --DBMS_OUTPUT.PUT_LINE('Check_Dim_Level_Default_Value v_Indicator ' || v_Indicator);
726: --DBMS_OUTPUT.PUT_LINE('Check_Dim_Level_Default_Value v_Dim_Level_Rec_R.Bsc_Level_View_Name ' || v_Dim_Level_Rec_R.Bsc_Level_View_Name);