DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_PROJ_STRUCTURE_TYPES

Line 6157: ,pa_proj_structure_types ppst

6153:
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

Line 6169: pa_proj_structure_types ppst,

6165: CURSOR cur_get_wp_versions IS
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'