SELECT pv.pv_id, pv.PKG_ID, p.PKG_NAME, pv.PKG_VERSION
FROM PACKAGE_DEPENDENCIES pd, PACKAGE_VERSIONS pv, PACKAGES p
WHERE pd.PV_ID =: PV_ID
AND pv.PV_ID = pd.DPV_ID
AND p.PKG_ID = pv.PKG_ID