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