[Home] [Help]
1423: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1424: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1425: AND Parent_Level_Index2 = cd.Dim_Level_Index;
1426:
1427: UPDATE BSC_KPI_DIM_LEVELS_TL
1428: SET Dim_Level_Index = l_count
1429: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1430: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1431: AND Dim_Level_Index = cd.Dim_Level_Index;