Cacher is the code snippet organizer for pro developers

-----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
 )