DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_STRUCTURE_TYPES

Line 6226: ,pa_structure_types pst

6222: CURSOR cur_get_wp_attr IS
6223: SELECT ppwa.*
6224: FROM pa_proj_workplan_attr ppwa
6225: ,pa_proj_structure_types ppst
6226: ,pa_structure_types pst
6227: WHERE ppwa.project_id = p_src_project_id
6228: AND ppwa.proj_element_id = ppst.proj_element_id
6229: AND ppst.structure_type_id = pst.structure_type_id
6230: AND pst.structure_type = 'WORKPLAN' ;

Line 6238: pa_structure_types pst,

6234: SELECT ppev.element_version_id, ppevs.status_code,
6235: ppevs.latest_eff_published_flag, ppevs.current_flag, ppevs.current_working_flag
6236: FROM pa_proj_element_versions ppev,
6237: pa_proj_structure_types ppst,
6238: pa_structure_types pst,
6239: pa_proj_elem_ver_structure ppevs
6240: WHERE ppev.project_id = p_src_project_id
6241: AND ppev.object_type = 'PA_STRUCTURES'
6242: AND ppev.element_version_id = ppevs.element_version_id