APPS.PA_XC_PROJECT_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 117: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev

113: -- Retrieve tasks from PA_PROJ_ELEMENTS table
114: CURSOR pa_proj_elements_csr(c_structure_version_id NUMBER, c_project_id NUMBER)
115: IS
116: SELECT ppe.proj_element_id, ppe.name, ppe.element_number, ppe.description, ppe.pm_source_reference, ppe.manager_person_id, ppe.carrying_out_organization_id
117: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev
118: WHERE ppe.project_id = c_project_id
119: AND ppe.project_id = ppev.project_id -- 3693934 added for peformance fix
120: AND ppe.object_type = 'PA_TASKS'
121: AND ppe.proj_element_id = ppev.proj_element_id

Line 132: FROM PA_PROJ_ELEMENT_VERSIONS ppev, PA_PROJ_ELEM_VER_SCHEDULE ppevs

128: -- Retrieve task Scheduled Start and Scheduled End Date from PA_PROJ_ELEM_VER_SCHEDULE table
129: CURSOR pa_schedule_dates_csr (c_structure_version_id NUMBER, c_proj_element_id NUMBER)
130: IS
131: SELECT ppevs.scheduled_start_date, ppevs.scheduled_finish_date
132: FROM PA_PROJ_ELEMENT_VERSIONS ppev, PA_PROJ_ELEM_VER_SCHEDULE ppevs
133: WHERE ppev.element_version_id = ppevs.element_version_id
134: AND ppev.project_id = ppevs.project_id -- 3693934 added for peformance fix
135: AND ppev.object_type = 'PA_TASKS'
136: AND ppev.proj_element_id = c_proj_element_id

Line 150: PA_PROJ_ELEMENT_VERSIONS ppev,

146: CURSOR get_parent_id_csr (c_proj_element_id NUMBER)
147: IS
148: SELECT ppev2.proj_element_id
149: FROM PA_OBJECT_RELATIONSHIPS por,
150: PA_PROJ_ELEMENT_VERSIONS ppev,
151: PA_PROJ_ELEMENT_VERSIONS ppev2
152: WHERE por.relationship_type = 'S'
153: AND por.object_id_to1 = ppev.element_version_id
154: AND por.object_type_from = 'PA_TASKS'

Line 151: PA_PROJ_ELEMENT_VERSIONS ppev2

147: IS
148: SELECT ppev2.proj_element_id
149: FROM PA_OBJECT_RELATIONSHIPS por,
150: PA_PROJ_ELEMENT_VERSIONS ppev,
151: PA_PROJ_ELEMENT_VERSIONS ppev2
152: WHERE por.relationship_type = 'S'
153: AND por.object_id_to1 = ppev.element_version_id
154: AND por.object_type_from = 'PA_TASKS'
155: AND ppev.proj_element_id = c_proj_element_id

Line 173: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev

169: --hsiu added
170: --Bug 3302732: Commenting this cursor.
171: /*cursor l_pm_source_ref(c_structure_version_id NUMBER, c_project_id NUMBER) IS
172: select min(to_Number(ppe.pm_source_reference))
173: FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev
174: WHERE ppe.project_id = c_project_id
175: AND ppe.object_type = 'PA_TASKS'
176: AND ppe.proj_element_id = ppev.proj_element_id
177: AND ppev.parent_structure_version_id = c_structure_version_id; */

Line 621: FROM pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs

617: /*
618: CURSOR l_get_working_version_csr(c_structure_id NUMBER)
619: IS
620: SELECT ppev.element_version_id
621: FROM pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
622: WHERE ppev.proj_element_id = c_structure_id
623: AND ppev.element_version_id = ppevs.element_version_id
624: AND ppevs.published_date is null;
625: */

Line 642: FROM pa_proj_element_versions

638: -- HY get structure id
639: CURSOR l_get_struct_id_csr(c_structure__version_id NUMBER)
640: IS
641: SELECT proj_element_id
642: FROM pa_proj_element_versions
643: WHERE element_version_id = c_structure__version_id;
644:
645: -- HY check for valid project id, structure id, structure version id combination.
646: CURSOR l_check_proj_struct_ver_id_csr(c_project_id NUMBER, c_structure_id NUMBER,

Line 650: FROM pa_proj_element_versions

646: CURSOR l_check_proj_struct_ver_id_csr(c_project_id NUMBER, c_structure_id NUMBER,
647: c_structure_version_id NUMBER)
648: IS
649: SELECT 'Y'
650: FROM pa_proj_element_versions
651: WHERE project_id = c_project_id
652: and proj_element_id = c_structure_id
653: and element_version_id = c_structure_version_id;
654:

Line 668: FROM pa_proj_element_versions

664: CURSOR l_check_proj_ver_id_csr(c_project_id NUMBER,
665: c_structure_version_id NUMBER)
666: IS
667: SELECT 'Y'
668: FROM pa_proj_element_versions
669: WHERE project_id = c_project_id
670: and element_version_id = c_structure_version_id;
671:
672: l_project_id NUMBER;