DBA Data[Home] [Help]

APPS.PA_PROJECT_PVT dependencies on PA_STRUCTURE_TYPES

Line 3881: pa_structure_types pst

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
3885: AND pst.structure_type = p_structure_type)