APPS.BSC_COLOR_UPGRADE dependencies on BSC_KPI_MEASURE_S

Line 23: SELECT bsc_kpi_measure_s.NEXTVAL INTO l_id from dual;

19: BEGIN
20:
21: FOR l_kpi_measure_rec IN c_kpi_measure LOOP
22: BEGIN
23: SELECT bsc_kpi_measure_s.NEXTVAL INTO l_id from dual;
24: UPDATE bsc_kpi_analysis_measures_b
25: SET kpi_measure_id = l_id
26: WHERE indicator = l_kpi_measure_rec.indicator
27: AND analysis_option0 = l_kpi_measure_rec.analysis_option0