APPS.BSC_DIMENSION_SETS_PVT dependencies on BSC_KPI_ANALYSIS_OPTIONS_B

Line 2132: update BSC_KPI_ANALYSIS_OPTIONS_B

2128: l_option_id := p_Dim_Set_Rec.Bsc_Analysis_Id;
2129: END IF;
2130: if upper(p_Dim_Set_Rec.Bsc_Action) = 'RESET' then
2131:
2132: update BSC_KPI_ANALYSIS_OPTIONS_B
2133: set dim_set_id = 0
2134: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
2135: and analysis_group_id = l_option_id
2136: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;

Line 2147: update BSC_KPI_ANALYSIS_OPTIONS_B

2143: within an indicator, we assign all the analysis
2144: options the defualt dimension set i.e "0" */
2145: else
2146:
2147: update BSC_KPI_ANALYSIS_OPTIONS_B
2148: set dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
2149: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
2150: and analysis_group_id = l_option_id
2151: and option_id = p_Dim_Set_Rec.Bsc_Option_Id;