Connect Prior Query
-----To get sections
SELECT to_char(section_no) id, section_desc name, section_desc_s name0
FROM hrs_sections
START WITH parent_section IN (SELECT section_no
FROM hrs_sections
WHERE staff_id = (SELECT staff_id
FROM hrs_staff
WHERE user_id = :parameter.p_user_id))
CONNECT BY PRIOR section_no = parent_section
----- to get employees
SELECT TO_CHAR (a.staff_id) ID, a.first_name || ' ' || a.father_name || ' ' || a.mid_name || ' ' || a.last_name NAME, a.first_name_s || ' ' || a.father_name_s || ' ' || a.mid_name_s || ' ' || a.last_name_s name0
FROM hrs_staff a
WHERE a.section_no in (SELECT section_no
FROM hrs_sections
START WITH parent_section IN (SELECT section_no
FROM hrs_sections
WHERE staff_id = (SELECT staff_id
FROM hrs_staff
WHERE user_id =1))-- :parameter.p_user_id))
CONNECT BY PRIOR section_no = parent_section
)