930: and object_type = 'PA_STRUCTURES'
931: and prg_group IS NOT NULL
932: and prg_group = x_prg_group
933: UNION
934: select /*+ index(pji_xbs_denorm pji_xbs_denorm_n5) */
935: prg_group, sup_level, sup_project_id
936: from pji_xbs_denorm
937: where x_prg_type <> 'PRG_PARENT'
938: and struct_type = 'PRG_BASE'
932: and prg_group = x_prg_group
933: UNION
934: select /*+ index(pji_xbs_denorm pji_xbs_denorm_n5) */
935: prg_group, sup_level, sup_project_id
936: from pji_xbs_denorm
937: where x_prg_type <> 'PRG_PARENT'
938: and struct_type = 'PRG_BASE'
939: and prg_group is not null
940: and struct_type is null