APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_PROGRESS_ROLLUP

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

3969:
3970: DELETE FROM pa_proj_elem_ver_schedule where project_id = p_project_id;
3971: DELETE FROM pa_proj_elem_ver_structure where project_id = p_project_id;
3972:
3973: /* Code to delete project records from tables: pa_progress_rollup, pa_proj_progress_attr
3974: and pa_proj_workplan_attr. */
3975:
3976: BEGIN
3977:

Line 14023: pa_progress_rollup ppr,

14019: pa_proj_elements ppe,
14020: pa_proj_element_versions ppv,
14021: pa_proj_elem_ver_structure ppvs,
14022: pa_proj_workplan_attr ppwa,
14023: pa_progress_rollup ppr,
14024: pji_xbs_plans_v pxpv
14025: WHERE
14026: ppv.project_id = ppa.project_id
14027: AND ppv.object_type IN( 'PA_STRUCTURES', 'PA_TASKS' )

Line 14046: pa_progress_rollup ppr2,

14042: AND Nvl(ppr.as_of_date, Trunc(SYSDATE)) =
14043: (
14044: SELECT Nvl(MAX(ppr2.as_of_date), Trunc(SYSDATE))
14045: FROM
14046: pa_progress_rollup ppr2,
14047: pa_proj_element_versions ppev,
14048: pa_proj_elem_ver_structure ppevs
14049: WHERE
14050: ppr2.object_id = ppv.proj_element_id

Line 14093: pa_progress_rollup ppr,

14089: pa_projects_all ppa,
14090: pa_proj_elements ppe,
14091: pa_proj_element_versions ppv,
14092: pa_proj_elem_ver_structure ppvs,
14093: pa_progress_rollup ppr,
14094: pji_xbs_plans_v pxpv
14095: WHERE
14096: ppa.project_id = ppv.project_id
14097: AND ppv.object_type IN( 'PA_STRUCTURES', 'PA_TASKS' )

Line 19427: from pa_progress_rollup ppr

19423: l_task_weight_basis_code := pa_progress_utils.get_task_weighting_basis(p_project_id => p_project_id);
19424: begin
19425: select max(as_of_date)
19426: into l_as_of_date
19427: from pa_progress_rollup ppr
19428: where ppr.project_id = p_project_id
19429: and ppr.structure_version_id is null
19430: and ppr.structure_type = 'WORKPLAN'
19431: and ppr.current_flag <> 'W'