DBA Data[Home] [Help]

APPS.PA_TIMELINE_PVT dependencies on PA_PROJECT_STATUSES

Line 1440: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

1436: (select fi1.resource_id,
1437: fi1.item_quantity,
1438: fi1.item_date,
1439: fi1.delete_flag
1440: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
1441: where (fi1.assignment_id = p_assignment_id
1442: or fi1.assignment_id in
1443: (select conflict_assignment_id
1444: from pa_assignment_conflict_hist

Line 1592: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

1588: (select fi1.resource_id,
1589: fi1.item_quantity,
1590: fi1.item_date,
1591: fi1.delete_flag
1592: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
1593: where (fi1.assignment_id = p_assignment_id
1594: or fi1.assignment_id in
1595: (select conflict_assignment_id
1596: from pa_assignment_conflict_hist

Line 1758: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

1754: (select fi1.resource_id,
1755: item_quantity,
1756: fi1.item_date,
1757: fi1.delete_flag
1758: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
1759: where (fi1.assignment_id = p_assignment_id
1760: or fi1.assignment_id in
1761: (select conflict_assignment_id
1762: from pa_assignment_conflict_hist

Line 1821: from pa_forecast_items fi3, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

1817: (select fi3.resource_id,
1818: fi3.item_quantity,
1819: fi3.global_exp_period_end_date,
1820: fi3.delete_flag
1821: from pa_forecast_items fi3, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
1822: where (fi3.assignment_id = p_assignment_id
1823: or fi3.assignment_id in
1824: (select conflict_assignment_id
1825: from pa_assignment_conflict_hist

Line 1993: from pa_forecast_items fi3, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

1989: (select fi3.resource_id,
1990: fi3.item_quantity,
1991: fi3.global_exp_period_end_date,
1992: fi3.delete_flag
1993: from pa_forecast_items fi3, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
1994: where (fi3.assignment_id = p_assignment_id
1995: or fi3.assignment_id in
1996: (select conflict_assignment_id
1997: from pa_assignment_conflict_hist