DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_PROGRESS_ROLLUP

Line 3752: /* Code to delete project records from tables: pa_progress_rollup, pa_proj_progress_attr

3748:
3749: DELETE FROM pa_proj_elem_ver_schedule where project_id = p_project_id;
3750: DELETE FROM pa_proj_elem_ver_structure where project_id = p_project_id;
3751:
3752: /* Code to delete project records from tables: pa_progress_rollup, pa_proj_progress_attr
3753: and pa_proj_workplan_attr. */
3754:
3755: BEGIN
3756:

Line 18634: from pa_progress_rollup ppr

18630: l_task_weight_basis_code := pa_progress_utils.get_task_weighting_basis(p_project_id => p_project_id);
18631: begin
18632: select max(as_of_date)
18633: into l_as_of_date
18634: from pa_progress_rollup ppr
18635: where ppr.project_id = p_project_id
18636: and ppr.structure_version_id is null
18637: and ppr.structure_type = 'WORKPLAN'
18638: and ppr.current_flag <> 'W'