oracle sql

select * from PDS_DELIVERY_REQUEST_INFO delivery left join PDS_ORDER_INFO orderInfo on (delivery.DELIVERY_ID = orderInfo.DELIVERY_ID)
         left join PDS_DELIVERY_TASK task on (delivery.DELIVERY_ID = task.DELIVERY_ID)
         where 1=1  and delivery.DEPARTMENT_CODE in (
                 select dept_no from (select t.dept_no as dept_no from pds_dept_info t
                 start with t.dept_no = '202'
                 connect by prior t.dept_no = t.parent_deptno
                 order by t.dept_no)
            )