[Home] [Help]
148: -- Select the number of the last analysis option plus 1 more for the given KPI
149: -- and give Analysis Group.
150: select max(option_id) + 1
151: into l_Anal_Opt_Rec.Bsc_Analysis_Option_Id
152: from BSC_KPI_ANALYSIS_OPTIONS_B
153: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
154: and analysis_group_id = l_Anal_Opt_Rec.Bsc_Analysis_Group_Id;
155:
156: -- Set the value for the Bsc_Option_Group0 equal to the value for the