DBA Data[Home] [Help]

APPS.PA_STATUS_PUB dependencies on PA_PROGRESS_ROLLUP

Line 2902: from pa_progress_rollup where project_id= l_project_id_out;

2898:
2899: /* bug 6917961 */
2900:
2901: select nvl(max(as_of_date),sysdate) into l_max_as_of_date
2902: from pa_progress_rollup where project_id= l_project_id_out;
2903:
2904:
2905:
2906: update pa_progress_rollup

Line 2906: update pa_progress_rollup

2902: from pa_progress_rollup where project_id= l_project_id_out;
2903:
2904:
2905:
2906: update pa_progress_rollup
2907: set COMPLETED_PERCENTAGE = null
2908: where project_id = l_project_id_out
2909: AND OBJECT_TYPE ='PA_TASKS'
2910: AND CURRENT_FLAG='Y'