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.PA_FORECAST_ITEMS_UTILS dependencies on PA_PROJECT_STATUSES

Line 207: pa_project_statuses pst

203: sch.forecast_txn_generated_flag forecast_txn_generated_flag,
204: pst.project_system_status_code system_status_code
205: FROM pa_schedules sch,
206: pa_project_assignments prasgn,
207: pa_project_statuses pst
208: WHERE ( ( p_start_date BETWEEN sch.start_date AND sch.end_date)
209: OR ( p_end_date BETWEEN sch.start_date AND sch.end_date)
210: OR ( p_start_date < sch.start_date AND p_end_date > sch.end_date) )
211: AND sch.assignment_id = prasgn.assignment_id

Line 310: FROM pa_schedules sch, pa_project_statuses pst

306: sch.end_date end_date,
307: sch.forecast_txn_version_number forecast_txn_version_number,
308: sch.forecast_txn_generated_flag forecast_txn_generated_flag,
309: pst.project_system_status_code system_status_code
310: FROM pa_schedules sch, pa_project_statuses pst
311: WHERE p_start_date IS NOT NULL
312: AND sch.status_code = pst.project_status_code
313: AND p_end_date IS NOT NULL
314: AND sch.assignment_id=p_assignment_id

Line 338: FROM pa_schedules sch, pa_project_statuses pst

334: sch.end_date end_date,
335: sch.forecast_txn_version_number forecast_txn_version_number,
336: sch.forecast_txn_generated_flag forecast_txn_generated_flag,
337: pst.project_system_status_code system_status_code
338: FROM pa_schedules sch, pa_project_statuses pst
339: WHERE p_start_date IS NULL
340: AND p_end_date IS NULL
341: AND sch.assignment_id=p_assignment_id
342: AND sch.status_code = pst.project_status_code