DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_STRUCTURE_TYPES

Line 6158: ,pa_structure_types pst

6154: CURSOR cur_get_wp_attr IS
6155: SELECT ppwa.*
6156: FROM pa_proj_workplan_attr ppwa
6157: ,pa_proj_structure_types ppst
6158: ,pa_structure_types pst
6159: WHERE ppwa.project_id = p_src_project_id
6160: AND ppwa.proj_element_id = ppst.proj_element_id
6161: AND ppst.structure_type_id = pst.structure_type_id
6162: AND pst.structure_type = 'WORKPLAN' ;

Line 6170: pa_structure_types pst,

6166: SELECT ppev.element_version_id, ppevs.status_code,
6167: ppevs.latest_eff_published_flag, ppevs.current_flag, ppevs.current_working_flag
6168: FROM pa_proj_element_versions ppev,
6169: pa_proj_structure_types ppst,
6170: pa_structure_types pst,
6171: pa_proj_elem_ver_structure ppevs
6172: WHERE ppev.project_id = p_src_project_id
6173: AND ppev.object_type = 'PA_STRUCTURES'
6174: AND ppev.element_version_id = ppevs.element_version_id