View: BEN_ELIGY_PRFL_RL_D

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

View Text

SELECT ERL.ROWID ROW_ID
, ERL.ELIGY_PRFL_RL_ID
, ERL.EFFECTIVE_START_DATE
, ERL.EFFECTIVE_END_DATE
, ERL.ORDR_TO_APLY_NUM
, FORMULA.FORMULA_NAME
, ELIGY_PRFL.NAME
, DRVBL_FCTR_APLS.MEANING
, ERL.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_ELIGY_PRFL_RL_F ERL
, FND_USER FUSER
, FF_FORMULAS_F FORMULA
, BEN_ELIGY_PRFL_F ELIGY_PRFL
, HR_LOOKUPS DRVBL_FCTR_APLS
WHERE FUSER.USER_ID (+)= ERL .LAST_UPDATED_BY
AND FORMULA.FORMULA_ID (+)= ERL .FORMULA_ID
AND ELIGY_PRFL.ELIGY_PRFL_ID (+)= ERL .ELIGY_PRFL_ID
AND DRVBL_FCTR_APLS.LOOKUP_CODE (+)= ERL .DRVBL_FCTR_APLS_FLAG
AND DRVBL_FCTR_APLS.LOOKUP_TYPE (+)= 'YES_NO'

Columns