522: ppf.current_employee_flag = 'Y' or ppf.current_npw_flag = 'Y') )) )
523: AND asg.organization_id in
524: (select o.organization_id_child from
525: (SELECT o.organization_id_child
526: FROM per_org_structure_elements o
527: CONNECT BY o.organization_id_parent = PRIOR o.organization_id_child
528: AND o.org_structure_version_id = PRIOR o.org_structure_version_id
529: AND LEVEL <= NVL(p_plan_rec.hierarchy_levels, LEVEL)
530: START WITH o.organization_id_parent = p_plan_rec.top_organization_id