DBA Data[Home] [Help]

APPS.PA_PROJECT_PVT dependencies on PA_PROJ_STRUCTURE_TYPES

Line 3880: pa_proj_structure_types ppst,

3876: WHERE PM_SOURCE_REFERENCE = p_pm_task_reference
3877: AND project_id = p_pa_project_id
3878: AND parent_structure_id = ( SELECT ppe.proj_element_id --Added this subQry for bug#3653517
3879: FROM pa_proj_elements ppe,
3880: pa_proj_structure_types ppst,
3881: pa_structure_types pst
3882: WHERE ppe.proj_element_id = ppst.proj_element_id
3883: AND ppe.project_id = p_pa_project_id
3884: AND ppst.structure_type_id = pst.structure_type_id

Line 10669: FROM pa_proj_elements ppe, pa_proj_structure_types ppst

10665: IS
10666: CURSOR cur_proj_elems
10667: IS
10668: SELECT ppe.proj_element_id
10669: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
10670: WHERE ppe.proj_element_id = ppst.proj_element_id
10671: AND ppe.project_id = p_project_id
10672: AND ppe.object_type = 'PA_STRUCTURES'
10673: AND ppst.structure_type_id = 1 ;

Line 10677: FROM pa_proj_structure_types b

10673: AND ppst.structure_type_id = 1 ;
10674:
10675: CURSOR c1( c_proj_element_id NUMBER ) is
10676: SELECT d.element_version_id
10677: FROM pa_proj_structure_types b
10678: ,pa_proj_elem_ver_structure d
10679: WHERE d.project_id = p_project_id
10680: AND 1 = b.structure_type_id
10681: AND b.proj_element_id = c_proj_element_id