DBA Data[Home] [Help]

APPS.CE_FORECAST_UTILS dependencies on DUAL

Line 489: from dual;

485: l_drilldown_flag VARCHAR2(1);
486: BEGIN
487: select ce_forecast_headers_s.nextval
488: into l_forecast_header_id
489: from dual;
490:
491: INSERT INTO ce_forecast_headers(
492: forecast_header_id,
493: name,

Line 582: from dual;

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(
585: forecast_row_id,
586: forecast_header_id,

Line 772: from dual;

768:
769: FOR p_fcol in C_fcol LOOP
770: select ce_forecast_columns_s.nextval
771: into l_forecast_column_id
772: from dual;
773:
774: INSERT INTO ce_forecast_columns(
775: forecast_column_id,
776: forecast_header_id,

Line 848: from dual;

844:
845: FOR p_fperiod in C_fperiod LOOP
846: select ce_forecast_periods_s.nextval
847: into l_forecast_period_id
848: from dual;
849:
850: INSERT INTO ce_forecast_periods(
851: forecast_period_id,
852: forecast_header_id,