APPS.PA_PROJECT_INTEGRATION_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 713: from pa_proj_element_versions a , pa_proj_elem_ver_structure s, pa_proj_elements c, pa_proj_element_versions d,

709:
710: --Changed this query for fetching correct tasks in case of split structures.
711: select a.element_version_id , a.proj_element_id , c.element_number bulk collect
712: into l_elem_ver_id_tbl,l_task_id_tbl , l_task_num_tbl
713: from pa_proj_element_versions a , pa_proj_elem_ver_structure s, pa_proj_elements c, pa_proj_element_versions d,
714: pa_proj_structure_types PPST, pa_integration_settings pis
715: where s.project_id = L_PROJECT_OUT_OBJ.PA_PROJECT_ID
716: and s.project_id = a.project_id
717: and a.parent_structure_version_id = s.element_version_id

Line 2458: from PA_PROJ_ELEMENT_VERSIONS a , pa_proj_elements c

2454:
2455:
2456: select a.proj_element_id , a.element_version_id
2457: bulk collect into X_DELETE_TASK_ID_TBL, X_DELETE_TASK_VER_ID_TBL
2458: from PA_PROJ_ELEMENT_VERSIONS a , pa_proj_elements c
2459: where a.project_id = P_PROJECT_IN_REC.pa_project_id
2460: and a.parent_structure_version_id = P_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID
2461: and a.object_type = 'PA_TASKS'
2462: and a.proj_element_id = c.proj_element_id

Line 2571: from pa_resource_assignments res1 , pa_budget_versions bud1 , PA_PROJ_ELEMENT_VERSIONS a

2567: log_pvt('DEL_RES','Before select '|| l_res_id_tbl.count);
2568:
2569: Select res1.resource_assignment_id , res1.task_id , a.element_version_id bulk collect
2570: into l_del_res_id_tbl, l_del_task_id_tbl, l_del_task_ver_id_tbl
2571: from pa_resource_assignments res1 , pa_budget_versions bud1 , PA_PROJ_ELEMENT_VERSIONS a
2572: where bud1.project_structure_version_id = P_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID
2573: and bud1.budget_version_id = res1.budget_version_id
2574: and a.proj_element_id = res1.task_id
2575: and a.parent_structure_version_id = bud1.project_structure_version_id