/* Package History */
SELECT TO_CHAR( pt.DATE_TIME_STAMP,'DD-MON-YYYY HH24:MI:SS' ) AS DATE_TIME_STAMP,
	   pt.TRAIL_ACTION,
	   usr.FULL_NAME,
	   usr.USER_EMAIL
  FROM PACKAGE_TRAIL pt,
  	   USERS usr
 WHERE pt.USER_ID = usr.USER_ID
   AND pt.PKG_ID = ( SELECT PKG_ID FROM PACKAGE_VERSIONS WHERE PV_ID=:PROD_ID
		)	
 ORDER BY pt.DATE_TIME_STAMP DESC      
 