Subversion Repositories DevTools

SELECT DISTINCT pkg_id
FROM package_dependencies dep
CONNECT BY PRIOR pkg_id = dpkg_id AND pv_id IN ($RELIST$)
START WITH dpkg_id IN ($L1PKGS$) 
AND pv_id IN (SELECT pv_id FROM release_content WHERE rtag_id = $RTAG_ID$)
AND pkg_id NOT IN ($L1DEPREQ$)