Контроль создания адреса

select
ad.ID
,(SELECT c.RV_ABBREVIATION FROM CG_REF_CODES c WHERE  c.RV_LOW_VALUE= ad.R_LEVEL AND  c.RV_DOMAIN='ADR УРОВЕНЬ АДРЕСА (СПИСОК)')"УрАдр"
,AD.R_LEVEL
,AD.NAME
,RP.EMP_NAME(ad.Inserted_by) "Сотрудник"
,(SELECT  wm_concat(NAME)
      FROM adr_address_voc
START WITH adr_address_voc.ID = ad.ID
CONNECT BY adr_address_voc.ID = PRIOR adr_address_voc.par_id) "Адрес"
from 
adr_address_voc ad
where
ad.inserted BETWEEN TO_DATE ('&start#', 'dd.mm.yyyy') AND TO_DATE ('&end#', 'dd.mm.yyyy')
and AD.R_LEVEL <40
and ad.dept_id is not null