SELECT pp.PATCH_ID, pv.PKG_VERSION, pkg.pkg_name
 FROM PACKAGE_PATCHES pp, PACKAGE_VERSIONS pv, PACKAGES pkg
 WHERE pp.PV_ID = (
  	   			  /* Patch Parent */
				  SELECT pp.PV_ID
				  FROM PACKAGE_PATCHES pp
				  WHERE pp.PATCH_ID = :PV_ID
  	   			  )  
AND pv.PV_ID = pp.PATCH_ID
AND pkg.PKG_ID = pv.PKG_ID
ORDER BY PKG_VERSION	