DBA Data[Home] [Help]

APPS.PA_FORECAST_ITEMS_UTILS dependencies on PA_PROJECT_ASSIGNMENTS

Line 206: pa_project_assignments prasgn,

202: sch.forecast_txn_version_number forecast_txn_version_number,
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) )