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 1769: FROM pa_proj_structure_types ppst

1765: THEN
1766: UPDATE pa_proj_elements ppe
1767: SET progress_outdated_flag = 'N'
1768: WHERE proj_element_id = ( SELECT proj_element_id
1769: FROM pa_proj_structure_types ppst
1770: WHERE ppst.structure_type_id = 1 --WORKPLAN
1771: AND ppst.proj_element_id = ppe.proj_element_id )
1772: AND project_id = p_project_id;
1773: END IF;

Line 1906: 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

1902: decode(ppe.object_type,'PA_TASKS',ptt.PROG_ENTRY_ENABLE_FLAG,'Y'),
1903: pppa.ALLOW_COLLAB_PROG_ENTRY,
1904: pppa.ALLOW_PHY_PRCNT_CMP_OVERRIDES,
1905: pppa.TASK_WEIGHT_BASIS_CODE
1906: 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
1907: WHERE ppe.project_id = p_project_id
1908: AND ppe.proj_element_id = p_object_id
1909: AND ppe.object_type = p_object_type
1910: AND ppe.type_id = ptt.task_type_id(+)

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

2613: -- This cursor obtains the task weight basis code for the project id.
2614: Cursor cur_weight_basis_code (c_project_id pa_projects_all.project_id%TYPE)
2615: Is
2616: Select ppa.task_weight_basis_code
2617: From pa_proj_progress_attr ppa,pa_proj_structure_types pst,pa_structure_types st
2618: Where ppa.project_id = c_project_id
2619: And ppa.object_type = 'PA_STRUCTURES'
2620: And ppa.structure_type = p_structure_type -- FPM Dev CR 3
2621: And ppa.object_id = pst.proj_element_id