View: BEN_LER_D

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

View Text

SELECT LER.ROWID ROW_ID
, LER.LER_ID
, LER.EFFECTIVE_START_DATE
, LER.EFFECTIVE_END_DATE
, LER.NAME
, TYP.MEANING
, CK_RLTD_PER_ELIG.MEANING
, LER_EVAL.FORMULA_NAME
, CM_APLY.MEANING
, OVRIDG_LE.MEANING
, WHN_TO_PRCS.MEANING
, LER.DESC_TXT
, LER.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
, LER.SHORT_NAME
, LER.SHORT_CODE
FROM BEN_LER_F LER
, FND_USER FUSER
, HR_LOOKUPS TYP
, HR_LOOKUPS WHN_TO_PRCS
, HR_LOOKUPS CK_RLTD_PER_ELIG
, HR_LOOKUPS CM_APLY
, HR_LOOKUPS OVRIDG_LE
, FF_FORMULAS_F LER_EVAL
WHERE FUSER.USER_ID (+)= LER.LAST_UPDATED_BY
AND TYP.LOOKUP_CODE (+)= LER.TYP_CD
AND TYP.LOOKUP_TYPE (+)= 'BEN_LER_TYP'
AND WHN_TO_PRCS.LOOKUP_CODE (+)= LER.WHN_TO_PRCS_CD
AND WHN_TO_PRCS.LOOKUP_TYPE (+)= 'BEN_WHN_TO_PRCS_LER'
AND CK_RLTD_PER_ELIG.LOOKUP_CODE (+)= LER.CK_RLTD_PER_ELIG_FLAG
AND CK_RLTD_PER_ELIG.LOOKUP_TYPE (+)= 'YES_NO'
AND CM_APLY.LOOKUP_CODE (+)= LER.CM_APLY_FLAG
AND CM_APLY.LOOKUP_TYPE (+)= 'YES_NO'
AND OVRIDG_LE.LOOKUP_CODE (+)= LER.OVRIDG_LE_FLAG
AND OVRIDG_LE.LOOKUP_TYPE (+)= 'YES_NO'
AND LER_EVAL.FORMULA_ID (+)= LER.LER_EVAL_RL
AND LER.EFFECTIVE_START_DATE BETWEEN LER_EVAL.EFFECTIVE_START_DATE(+)
AND LER_EVAL.EFFECTIVE_END_DATE(+)

Columns