APPS.PA_PROJECT_INTEGRATION_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 641: from pa_proj_elem_ver_structure s,

637:
638: /**
639: select s.element_version_id
640: into L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID
641: from pa_proj_elem_ver_structure s,
642: pa_proj_structure_types ppst,
643: pa_structure_types pst
644: where s.project_id = L_PROJECT_OUT_OBJ.pa_project_id
645: and ( ( s.status_code = 'STRUCTURE_WORKING' AND

Line 662: from pa_proj_elem_ver_structure s,

658: and pst.structure_type_class_code = 'WORKPLAN';
659: **/
660: select s.element_version_id, cost_resource_list_id
661: into L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID, l_cost_resource_list_id
662: from pa_proj_elem_ver_structure s,
663: pa_proj_structure_types ppst,
664: pa_structure_types pst,
665: pa_budget_versions bud,
666: pa_proj_fp_options opt

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 1870: from pa_proj_elem_ver_structure ppevs,

1866:
1867: else
1868: select ppevs.element_version_id
1869: into L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID
1870: from pa_proj_elem_ver_structure ppevs,
1871: pa_proj_structure_types ppst,
1872: pa_structure_types pst
1873: where ppevs.proj_element_id = ppst.proj_element_id
1874: and ppevs.project_id = l_PROJECT_IN_OBJ.PA_PROJECT_ID