eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_FORECAST_PVT dependencies on GL_PERIODS

Line 522: FROM gl_periods glp

518: l_asset_query := false;
519:
520: SELECT glp.start_date
521: INTO l_start_date
522: FROM gl_periods glp
523: WHERE glp.period_name = p_forecast_rec.period_from
524: AND glp.period_set_name = p_forecast_rec.period_set_name_from;
525:
526: debug('Start date is ' || l_start_date);

Line 530: FROM gl_periods glp

526: debug('Start date is ' || l_start_date);
527:
528: SELECT glp.end_date
529: INTO l_end_date
530: FROM gl_periods glp
531: WHERE glp.period_name = p_forecast_rec.period_to
532: AND glp.period_set_name = p_forecast_rec.period_set_name_to;
533:
534: debug('End date is ' || l_end_date);

Line 1160: period_start_date > (select start_date from gl_periods

1156: -- that have no costs associated with them
1157:
1158: -- delete all costs not within the horizon
1159: delete from eam_forecast_cebba where forecast_id = p_forecast_id AND
1160: period_start_date > (select start_date from gl_periods
1161: where
1162: period_set_name = v_forecast_rec.period_set_name_to
1163: and period_name = v_forecast_rec.period_to);
1164:

Line 1440: FROM gl_periods glp

1436:
1437:
1438: SELECT glp.start_date
1439: INTO l_start_date
1440: FROM gl_periods glp
1441: WHERE glp.period_name = p_forecast_rec.period_from
1442: AND glp.period_set_name = p_forecast_rec.period_set_name_from;
1443:
1444: SELECT glp.end_date

Line 1446: FROM gl_periods glp

1442: AND glp.period_set_name = p_forecast_rec.period_set_name_from;
1443:
1444: SELECT glp.end_date
1445: INTO l_end_date
1446: FROM gl_periods glp
1447: WHERE glp.period_name = p_forecast_rec.period_to
1448: AND glp.period_set_name = p_forecast_rec.period_set_name_to;
1449:
1450: select wip_job_schedule_interface_s.nextval into l_pm_group_id from dual;

Line 3023: FROM gl_periods glp, gl_periods glp2, gl_periods glp3, eam_forecasts ef2

3019: )
3020: FROM
3021:
3022: (SELECT glp.period_name, glp.start_date, ef2.forecast_id
3023: FROM gl_periods glp, gl_periods glp2, gl_periods glp3, eam_forecasts ef2
3024: WHERE
3025: glp.start_date >= glp2.start_date
3026: AND glp.end_date <= glp3.end_date
3027: AND glp.period_type = glp2.period_type