DBA Data[Home] [Help]

APPS.PA_STATUS_PUB dependencies on PA_PROGRESS_ROLLUP

Line 2803: from pa_progress_rollup where project_id= l_project_id_out;

2799:
2800: /* bug 6917961 */
2801:
2802: select nvl(max(as_of_date),sysdate) into l_max_as_of_date
2803: from pa_progress_rollup where project_id= l_project_id_out;
2804:
2805:
2806:
2807: update pa_progress_rollup

Line 2807: update pa_progress_rollup

2803: from pa_progress_rollup where project_id= l_project_id_out;
2804:
2805:
2806:
2807: update pa_progress_rollup
2808: set COMPLETED_PERCENTAGE = null
2809: where project_id = l_project_id_out
2810: AND OBJECT_TYPE ='PA_TASKS'
2811: AND CURRENT_FLAG='Y'