APPS.PA_PROJECT_INTEGRATION_PUB dependencies on PA_PROJ_STRUCTURE_TYPES

Line 642: pa_proj_structure_types ppst,

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
646: exists ( select 'x' from pa_proj_workplan_attr w1

Line 663: pa_proj_structure_types ppst,

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
667: where s.project_id = L_PROJECT_OUT_OBJ.pa_project_id

Line 714: pa_proj_structure_types PPST, pa_integration_settings pis

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
718: and a.object_type = 'PA_TASKS'

Line 1871: pa_proj_structure_types ppst,

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
1875: and ( ( ppevs.status_code = 'STRUCTURE_WORKING' AND