APPS.PA_ASSIGNMENT_PROGRESS_PUB dependencies on PA_PROJ_ELEMENTS

Line 475: , pa_proj_elements ppe

471: , ppr.actual_start_date
472: , ppr.actual_finish_date
473: , ppe.status_code
474: FROM pa_progress_rollup ppr
475: , pa_proj_elements ppe
476: WHERE ppr.project_id = c_project_id
477: AND ppr.object_id = c_object_id
478: AND ppr.object_type = c_object_type
479: AND ppr.structure_type = 'WORKPLAN'

Line 586: FROM pa_proj_elements ppe,

582: x_return_status := FND_API.G_RET_STS_SUCCESS;
583:
584: SELECT DECODE(ptt.REMAIN_EFFORT_ENABLE_FLAG, 'Y', DECODE(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', 'Y', 'N'), 'N')
585: INTO l_est_remaining_eff_flag
586: FROM pa_proj_elements ppe,
587: pa_task_types ptt ,
588: pa_proj_progress_attr pppa
589: WHERE ppe.proj_element_id = p_task_id
590: AND ppe.type_id = ptt.task_type_id

Line 1980: UPDATE pa_proj_elements

1976: --If etc is not passed then it can be taken as not overidden and let summarization do plann - actual.
1977: IF l_etc_effort_this_period IS NOT NULL OR
1978: l_etc_raw_cost_this_period IS NOT NULL
1979: THEN
1980: UPDATE pa_proj_elements
1981: SET progress_outdated_flag = 'Y'
1982: WHERE project_id=p_project_id
1983: and object_type= 'PA_TASKS'
1984: and proj_element_id = p_task_id