PeopleSoft GP rule package comparing result by SQL

There are more than 20 times that my staged result got cleared from front end by some other people (I’m not telling who they are).

One good part is, if the data are not flushed in database, we can still see the result.

SELECT *
FROM PS_GP_PKG_ELEMENTS ELE, PS_GP_PINTYPE_VW PINTYPE, PSXLATITEM XLAT
  WHERE ELE.GP_PKG_ID        = '<PACKAGE_NAME>'
    AND XLAT.fieldname         = 'GP_PKG_FAIL_REASON'
    AND ELE.PIN_TYPE = PINTYPE.PIN_TYPE
    AND ELE.GP_PKG_FAIL_REASON = XLAT.FIELDVALUE;

--
select count(*)
from PS_GP_PKG_ELEMENTS ELE
  where ELE.GP_PKG_ID = '<PACKAGE_NAME>';