View: BEN_PRTT_RMT_APRVD_FR_PYMT_D

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_PRTT_RMT_APRVD_FR_PYMT_D

View Text

SELECT PRY.PRTT_RMT_APRVD_FR_PYMT_ID
, PRY.PRTT_REIMBMT_RQST_ID
, PRY.EFFECTIVE_START_DATE
, PRY.EFFECTIVE_END_DATE
, PRY.APPRVD_FR_PYMT_NUM
, PRY.ADJMT_FLAG
, PRY.APRVD_FR_PYMT_AMT
, PRY.PYMT_STAT_CD
, PRY.PYMT_STAT_RSN_CD
, PRY.PYMT_STAT_OVRDN_RSN_CD
, PRY.PYMT_STAT_PRR_TO_OVRD_CD
, PRY.BUSINESS_GROUP_ID
, PRY.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_PRTT_RMT_APRVD_FR_PYMT_F PRY
, FND_USER FUSER
WHERE FUSER.USER_ID(+)= PRY.LAST_UPDATED_BY

Columns