DBA Data[Home] [Help]

APPS.CE_FORECAST_UTILS dependencies on CE_FORECAST_PERIODS

Line 478: FROM ce_forecast_periods

474: creation_date,
475: last_updated_by,
476: last_update_date,
477: last_update_login
478: FROM ce_forecast_periods
479: WHERE forecast_header_id = X_forecast_header_id;
480:
481: l_forecast_header_id NUMBER;
482: l_forecast_row_id NUMBER;

Line 846: select ce_forecast_periods_s.nextval

842: end if;
843: END LOOP;
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(

Line 850: INSERT INTO ce_forecast_periods(

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,
853: level_of_summary,
854: period_number,

Line 885: | information in ce_forecast_periods |

881: | populate_temp_buckets |
882: | |
883: | DESCRIPTION |
884: | Populates ce_forecast_columns based on the aging-bucket |
885: | information in ce_forecast_periods |
886: | CALLED BY |
887: | populate_aging_buckets |
888: | REQUIRES |
889: | |

Line 906: FROM ce_forecast_periods

902: creation_date,
903: last_updated_by,
904: last_update_date,
905: last_update_login
906: FROM ce_forecast_periods
907: WHERE forecast_header_id = p_forecast_header_id
908: ORDER BY period_number;
909:
910: