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 521: FROM gl_periods glp

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

Line 529: FROM gl_periods glp

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

Line 1139: period_start_date > (select start_date from gl_periods

1135: -- that have no costs associated with them
1136:
1137: -- delete all costs not within the horizon
1138: delete from eam_forecast_cebba where forecast_id = p_forecast_id AND
1139: period_start_date > (select start_date from gl_periods
1140: where
1141: period_set_name = v_forecast_rec.period_set_name_to
1142: and period_name = v_forecast_rec.period_to);
1143:

Line 1419: FROM gl_periods glp

1415:
1416:
1417: SELECT glp.start_date
1418: INTO l_start_date
1419: FROM gl_periods glp
1420: WHERE glp.period_name = p_forecast_rec.period_from
1421: AND glp.period_set_name = p_forecast_rec.period_set_name_from;
1422:
1423: SELECT glp.end_date

Line 1425: FROM gl_periods glp

1421: AND glp.period_set_name = p_forecast_rec.period_set_name_from;
1422:
1423: SELECT glp.end_date
1424: INTO l_end_date
1425: FROM gl_periods glp
1426: WHERE glp.period_name = p_forecast_rec.period_to
1427: AND glp.period_set_name = p_forecast_rec.period_set_name_to;
1428:
1429: select wip_job_schedule_interface_s.nextval into l_pm_group_id from dual;

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

2694: )
2695: FROM
2696:
2697: (SELECT glp.period_name, glp.start_date, ef2.forecast_id
2698: FROM gl_periods glp, gl_periods glp2, gl_periods glp3, eam_forecasts ef2
2699: WHERE
2700: glp.start_date >= glp2.start_date
2701: AND glp.end_date <= glp3.end_date
2702: AND glp.period_type = glp2.period_type