select d.DEP_AR_ID
                      from depart_for_dispatcher d
                    connect by d.DEP_ID = prior d.PAR_DEP_ID
                     start with d.DEP_ID in
                                (select distinct dep_id
                                   from table(dispatcher_pkg.WORKER_DISP_UCH_INFO(V_WORKER_ID)))

WITH t AS
 (SELECT DISTINCT DEP_ID
  FROM TABLE(dispatcher_pkg.WORKER_DISP_UCH_INFO(260339659)))
SELECT a.DEP_AR_ID
FROM   argus_depart_for_dispatcher a
CONNECT BY a.DEP_AR_ID = PRIOR a.PAR_DEP_AR_ID
START  WITH a.DEP_AR_ID IN (SELECT t.dep_id FROM t)

WITH a AS
                       (SELECT DISTINCT DEP_ID
                       FROM   TABLE(dispatcher_pkg.WORKER_DISP_UCH_INFO(p_worker_id))),
                      a1 AS
                       (SELECT * FROM ARGUS_DEPART_FOR_DISPATCHER)
                      SELECT t.ar_reg_id,
                             t.ar_reg,
                             t.dep_ar_id,
                             t.disp_dep_name,
                             t.par_dep_ar_id
                      FROM   a1 t
                      START  WITH t.DEP_AR_ID IN (SELECT dep_id FROM a)
                      CONNECT BY t.DEP_AR_ID = PRIOR t.par_DEP_ar_ID