select pv.pv_id, pkg.pkg_name, pv.pkg_version from 
package_dependencies pd, 
package_versions pv,
packages pkg 
where pd.pv_id = :PV_ID
and pv.pv_id = pd.dpv_id
and pkg.pkg_id = pv.pkg_id