DBA Data[Home] [Help]

APPS.BSC_ANALYSIS_OPTION_PUB dependencies on BSC_KPI_ANALYSIS_OPTIONS_B

Line 152: from BSC_KPI_ANALYSIS_OPTIONS_B

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