[Home] [Help]
4070: AND project_id = p_pa_project_id
4071: AND parent_structure_id = ( SELECT ppe.proj_element_id --Added this subQry for bug#3653517
4072: FROM pa_proj_elements ppe,
4073: pa_proj_structure_types ppst,
4074: pa_structure_types pst
4075: WHERE ppe.proj_element_id = ppst.proj_element_id
4076: AND ppe.project_id = p_pa_project_id
4077: AND ppst.structure_type_id = pst.structure_type_id
4078: AND pst.structure_type = p_structure_type)