APPS.CE_FORECAST_UTILS dependencies on CE_FORECAST_ROWS

Line 213: FROM ce_forecast_rows

209: CURSOR C_fc IS SELECT forecast_id
210: FROM ce_forecasts
211: WHERE forecast_header_id = X_forecast_header_id;
212: CURSOR C_frow(p_forecast_id NUMBER) IS SELECT forecast_row_id
213: FROM ce_forecast_rows
214: WHERE forecast_header_id = X_forecast_header_id
215: AND forecast_row_id not in
216: (select forecast_row_id
217: from ce_forecast_cells

Line 221: FROM ce_forecast_rows

217: from ce_forecast_cells
218: where forecast_header_id = X_forecast_header_id
219: and forecast_id = p_forecast_id);
220: CURSOR C_frow_trx(p_forecast_id NUMBER) IS SELECT forecast_row_id
221: FROM ce_forecast_rows
222: WHERE forecast_header_id = X_forecast_header_id
223: AND forecast_row_id not in
224: (select forecast_row_id
225: from ce_forecast_trx_cells

Line 434: FROM ce_forecast_rows

430: use_average_payment_days,
431: period,
432: order_type_id,
433: use_payment_terms
434: FROM ce_forecast_rows
435: WHERE forecast_header_id = X_forecast_header_id;
436:
437: CURSOR C_fcol IS SELECT forecast_column_id,
438: forecast_header_id,

Line 580: select ce_forecast_rows_s.nextval

576: end if;
577:
578:
579: FOR p_frow in C_frow LOOP
580: select ce_forecast_rows_s.nextval
581: into l_forecast_row_id
582: from dual;
583:
584: INSERT INTO ce_forecast_rows(

Line 584: INSERT INTO ce_forecast_rows(

580: select ce_forecast_rows_s.nextval
581: into l_forecast_row_id
582: from dual;
583:
584: INSERT INTO ce_forecast_rows(
585: forecast_row_id,
586: forecast_header_id,
587: row_number,
588: trx_type,