Subversion Repositories DevTools

/* Find Package Version */

SELECT pv.PKG_VERSION,

	   pv.PV_ID,

	   pv.DLOCKED,

	   pv.MODIFIED_STAMP,

	   pv.COMMENTS,

	   usr.FULL_NAME,

	   usr.USER_EMAIL

  FROM PACKAGE_VERSIONS pv,

  	   USERS usr

 WHERE pv.PKG_ID = :PKG_ID

   AND pv.PKG_VERSION LIKE :PKG_VERSION

   AND pv.MODIFIER_ID = usr.USER_ID