VIEW: APPS.BEN_ELIGY_PRFL_D

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'