View: BEN_ELIGY_PRFL_D

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

View Text

SELECT ELP.ROWID ROW_ID
, ELP.ELIGY_PRFL_ID
, ELP.EFFECTIVE_START_DATE
, ELP.EFFECTIVE_END_DATE
, ELP.NAME
, ELP.DESCRIPTION
, STAT.MEANING
, ASMT.MEANING
, ELP.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_ELIGY_PRFL_F ELP
, FND_USER FUSER
, HR_LOOKUPS STAT
, HR_LOOKUPS ASMT
WHERE FUSER.USER_ID (+)= ELP.LAST_UPDATED_BY
AND STAT.LOOKUP_CODE (+)= ELP.STAT_CD
AND STAT.LOOKUP_TYPE (+)= 'BEN_STAT'
AND ASMT.LOOKUP_CODE (+)= ELP.ASMT_TO_USE_CD
AND ASMT.LOOKUP_TYPE (+)= 'BEN_ASMT_TO_USE'

Columns