DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_PROGRESS_PUB dependencies on PA_PROJ_ELEMENTS

Line 469: , pa_proj_elements ppe

465: , ppr.actual_start_date
466: , ppr.actual_finish_date
467: , ppe.status_code
468: FROM pa_progress_rollup ppr
469: , pa_proj_elements ppe
470: WHERE ppr.project_id = c_project_id
471: AND ppr.object_id = c_object_id
472: AND ppr.object_type = c_object_type
473: AND ppr.structure_type = 'WORKPLAN'

Line 1866: UPDATE pa_proj_elements

1862: --If etc is not passed then it can be taken as not overidden and let summarization do plann - actual.
1863: IF l_etc_effort_this_period IS NOT NULL OR
1864: l_etc_raw_cost_this_period IS NOT NULL
1865: THEN
1866: UPDATE pa_proj_elements
1867: SET progress_outdated_flag = 'Y'
1868: WHERE project_id=p_project_id
1869: and object_type= 'PA_TASKS'
1870: and proj_element_id = p_task_id