APPS.PA_PROGRESS_UTILS dependencies on PA_PROJ_STRUCTURE_TYPES

Line 57: pa_proj_structure_types ppst

53: from pa_proj_element_versions ppev1,
54: pa_proj_element_versions ppev2,
55: pa_proj_elem_ver_structure ppevs,
56: pa_structure_types pst,
57: pa_proj_structure_types ppst
58: where ppevs.project_id = p_project_id
59: and ppevs.latest_eff_published_flag = 'Y'
60: and ppevs.element_version_id = ppev1.parent_structure_version_id
61: and ppevs.element_version_id = ppev2.element_version_id

Line 101: pa_proj_structure_types ppst

97: into x_structure_version_id
98: from pa_proj_elem_ver_structure ppevs,
99: pa_proj_element_versions ppev,
100: pa_structure_types pst,
101: pa_proj_structure_types ppst
102: where ppevs.project_id = p_project_id
103: and ppevs.latest_eff_published_flag = 'Y'
104: and ppevs.element_version_id = ppev.element_version_id
105: and ppev.proj_element_id = ppst.proj_element_id

Line 1791: FROM pa_proj_structure_types ppst

1787: THEN
1788: UPDATE pa_proj_elements ppe
1789: SET progress_outdated_flag = 'N'
1790: WHERE proj_element_id = ( SELECT proj_element_id
1791: FROM pa_proj_structure_types ppst
1792: WHERE ppst.structure_type_id = 1 --WORKPLAN
1793: AND ppst.proj_element_id = ppe.proj_element_id )
1794: AND project_id = p_project_id;
1795: END IF;

Line 1928: FROM pa_proj_elements ppe, pa_task_types ptt, pa_proj_progress_attr pppa, pa_proj_elem_ver_structure ppvs, pa_proj_structure_types ppst

1924: decode(ppe.object_type,'PA_TASKS',ptt.PROG_ENTRY_ENABLE_FLAG,'Y'),
1925: pppa.ALLOW_COLLAB_PROG_ENTRY,
1926: pppa.ALLOW_PHY_PRCNT_CMP_OVERRIDES,
1927: pppa.TASK_WEIGHT_BASIS_CODE
1928: FROM pa_proj_elements ppe, pa_task_types ptt, pa_proj_progress_attr pppa, pa_proj_elem_ver_structure ppvs, pa_proj_structure_types ppst
1929: WHERE ppe.project_id = p_project_id
1930: AND ppe.proj_element_id = p_object_id
1931: AND ppe.object_type = p_object_type
1932: AND ppe.type_id = ptt.task_type_id(+)

Line 2642: From pa_proj_progress_attr ppa,pa_proj_structure_types pst,pa_structure_types st

2638: -- This cursor obtains the task weight basis code for the project id.
2639: Cursor cur_weight_basis_code (c_project_id pa_projects_all.project_id%TYPE)
2640: Is
2641: Select ppa.task_weight_basis_code
2642: From pa_proj_progress_attr ppa,pa_proj_structure_types pst,pa_structure_types st
2643: Where ppa.project_id = c_project_id
2644: And ppa.object_type = 'PA_STRUCTURES'
2645: And ppa.structure_type = p_structure_type -- FPM Dev CR 3
2646: And ppa.object_id = pst.proj_element_id