APPS.PA_STATUS_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 133: from pa_proj_element_versions elev,

129: and pst.structure_type_class_code = c_structure_type;
130:
131: CURSOR c_get_element_information(c_project_id NUMBER, c_proj_element_id NUMBER, c_object_type VARCHAR2, c_structure_type VARCHAR2) IS
132: select elev.element_version_id, elev.parent_structure_version_id
133: from pa_proj_element_versions elev,
134: pa_proj_structure_types ppst,
135: pa_structure_types pst,
136: pa_proj_elem_ver_structure ppevs
137: where elev.project_id = c_project_id

Line 164: FROM pa_proj_element_versions ppev

160:
161: --Begin Add by rtarway for BUG 3746647
162: CURSOR c_get_del_ver_id(c_project_id NUMBER, c_del_proj_element_id NUMBER) IS
163: SELECT ppev.element_version_id
164: FROM pa_proj_element_versions ppev
165: WHERE ppev.proj_element_id = c_del_proj_element_id
166: AND ppev.project_id = c_project_id
167: AND ppev.object_type = 'PA_DELIVERABLES' ;
168: --End Add by rtarway for BUG 3746647

Line 2774: from pa_proj_element_versions ppev1, pa_proj_element_versions ppev2

2770: END IF;
2771: begin
2772: Select ppev1.proj_element_id
2773: into l_structure_id
2774: from pa_proj_element_versions ppev1, pa_proj_element_versions ppev2
2775: where ppev2.element_version_id = l_object_version_id
2776: and ppev2.project_id = ppev1.project_id
2777: and ppev2.parent_structure_version_id = ppev1.element_version_id;
2778: exception when others then