View: BEN_LER_CHG_PGM_ENRT_D

Product:	BEN - Advanced Benefits
Description:	Life Event - Program Enrollment Date Track View
Implementation/DBA Data:	APPS.BEN_LER_CHG_PGM_ENRT_D

View Text

SELECT LGE.ROWID ROW_ID
, LGE.LER_CHG_PGM_ENRT_ID
, LGE.EFFECTIVE_START_DATE
, LGE.EFFECTIVE_END_DATE
, AUTO_ENRT_MTHD.FORMULA_NAME
, CRNT_ENRT_PRCLDS_CHG.MEANING
, PGM.NAME
, LER.NAME
, DFLT_ENRT.MEANING
, DFLT_ENRT2.FORMULA_NAME
, ENRT.MEANING
, ENRT_MTHD.MEANING
, ENRT2.FORMULA_NAME
, STL_ELIG_CANT_CHG.MEANING
, LGE.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_LER_CHG_PGM_ENRT_F LGE
, FND_USER FUSER
, BEN_PGM_F PGM
, BEN_LER_F LER
, HR_LOOKUPS DFLT_ENRT
, HR_LOOKUPS ENRT
, HR_LOOKUPS ENRT_MTHD
, HR_LOOKUPS CRNT_ENRT_PRCLDS_CHG
, HR_LOOKUPS STL_ELIG_CANT_CHG
, FF_FORMULAS_F AUTO_ENRT_MTHD
, FF_FORMULAS_F DFLT_ENRT2
, FF_FORMULAS_F ENRT2
WHERE FUSER.USER_ID (+)= LGE.LAST_UPDATED_BY AND PGM.PGM_ID (+)= LGE.PGM_ID AND LER.LER_ID (+)= LGE.LER_ID AND DFLT_ENRT.LOOKUP_CODE (+)= LGE.DFLT_ENRT_CD AND DFLT_ENRT.LOOKUP_TYPE (+)= 'BEN_DFLT_ENRT' AND ENRT.LOOKUP_CODE (+)= LGE.ENRT_CD AND ENRT.LOOKUP_TYPE (+)= 'BEN_ENRT' AND ENRT_MTHD.LOOKUP_CODE (+)= LGE.ENRT_MTHD_CD AND ENRT_MTHD.LOOKUP_TYPE (+)= 'BEN_ENRT_MTHD' AND CRNT_ENRT_PRCLDS_CHG.LOOKUP_CODE (+)= LGE.CRNT_ENRT_PRCLDS_CHG_FLAG AND CRNT_ENRT_PRCLDS_CHG.LOOKUP_TYPE (+)= 'YES_NO' AND STL_ELIG_CANT_CHG.LOOKUP_CODE (+)= LGE.STL_ELIG_CANT_CHG_FLAG AND STL_ELIG_CANT_CHG.LOOKUP_TYPE (+)= 'YES_NO' AND AUTO_ENRT_MTHD.FORMULA_ID (+)= LGE.AUTO_ENRT_MTHD_RL AND LGE.EFFECTIVE_START_DATE BETWEEN AUTO_ENRT_MTHD.EFFECTIVE_START_DATE(+)
AND AUTO_ENRT_MTHD.EFFECTIVE_END_DATE(+) AND DFLT_ENRT2.FORMULA_ID (+)= LGE.DFLT_ENRT_RL AND LGE.EFFECTIVE_START_DATE BETWEEN DFLT_ENRT2.EFFECTIVE_START_DATE(+)
AND DFLT_ENRT2.EFFECTIVE_END_DATE(+) AND ENRT2.FORMULA_ID (+)= LGE.ENRT_RL AND LGE.EFFECTIVE_START_DATE BETWEEN ENRT2.EFFECTIVE_START_DATE(+)
AND ENRT2.EFFECTIVE_END_DATE(+) AND LGE.EFFECTIVE_START_DATE BETWEEN PGM.EFFECTIVE_START_DATE(+)
AND PGM.EFFECTIVE_END_DATE(+) AND LGE.EFFECTIVE_START_DATE BETWEEN LER.EFFECTIVE_START_DATE(+)
AND LER.EFFECTIVE_END_DATE(+)

Columns