DBA Data[Home] [Help]

APPS.PA_PROJECT_INTEGRATION_PUB dependencies on PA_STRUCTURE_TYPES

Line 643: pa_structure_types pst

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
647: where w1.project_id = s.project_id

Line 664: pa_structure_types pst,

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

Line 1872: pa_structure_types pst

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