2732: SELECT a.project_id, a.element_version_id, a.prg_level
2733: FROM pa_proj_element_versions a,
2734: pa_proj_elem_ver_structure b,
2735: pa_proj_workplan_attr ppwa,
2736: pa_proj_structure_types ppst,
2737: pa_proj_element_versions c,
2738: pa_proj_elem_ver_structure b1,
2739: pa_proj_workplan_attr ppwa1,
2740: pa_proj_structure_types ppst1
2736: pa_proj_structure_types ppst,
2737: pa_proj_element_versions c,
2738: pa_proj_elem_ver_structure b1,
2739: pa_proj_workplan_attr ppwa1,
2740: pa_proj_structure_types ppst1
2741: WHERE
2742: c.project_id = p_project_id
2743: AND c.prg_group = a.prg_group
2744: -- **** Added for bug 13108355
2765: SELECT a.project_id, a.element_version_id, a.prg_level
2766: FROM pa_proj_element_versions a,
2767: pa_proj_elem_ver_structure b,
2768: pa_proj_workplan_attr ppwa,
2769: pa_proj_structure_types ppst,
2770: pa_proj_element_versions c,
2771: pa_proj_elem_ver_structure b1,
2772: pa_proj_workplan_attr ppwa1,
2773: pa_proj_structure_types ppst1
2769: pa_proj_structure_types ppst,
2770: pa_proj_element_versions c,
2771: pa_proj_elem_ver_structure b1,
2772: pa_proj_workplan_attr ppwa1,
2773: pa_proj_structure_types ppst1
2774: WHERE
2775: c.project_id = p_project_id
2776: AND c.prg_group = a.prg_group
2777: -- **** Added for bug 13108355