View: BEN_ELIG_DSBLD_STAT_CVG_D

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

View Text

SELECT EDC.ROWID ROW_ID
, EDC.ELIG_DSBLD_STAT_CVG_ID
, EDC.EFFECTIVE_START_DATE
, EDC.EFFECTIVE_END_DATE
, DPNT_CVG_ELIGY_PRFL.NAME
, CVG_STRT.MEANING
, CVG_STRT.FORMULA_NAME
, CVG_THRU.MEANING
, CVG_THRU.FORMULA_NAME
, DSBLD.MEANING
, EDC.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_DSBLD_STAT_CVG_F EDC
, FND_USER FUSER
, BEN_DPNT_CVG_ELIGY_PRFL_F DPNT_CVG_ELIGY_PRFL
, HR_LOOKUPS CVG_STRT
, HR_LOOKUPS CVG_THRU
, HR_LOOKUPS DSBLD
, FF_FORMULAS_F CVG_STRT
, FF_FORMULAS_F CVG_THRU
WHERE FUSER.USER_ID (+)= EDC.LAST_UPDATED_BY
AND DPNT_CVG_ELIGY_PRFL.DPNT_CVG_ELIGY_PRFL_ID (+)= EDC.DPNT_CVG_ELIGY_PRFL_ID
AND CVG_STRT.LOOKUP_CODE (+)= EDC.CVG_STRT_CD
AND CVG_STRT.LOOKUP_TYPE (+)= 'BEN_DPNT_CVG_STRT'
AND CVG_THRU.LOOKUP_CODE (+)= EDC.CVG_THRU_CD
AND CVG_THRU.LOOKUP_TYPE (+)= 'BEN_DPNT_CVG_END'
AND DSBLD.LOOKUP_CODE (+)= EDC.DSBLD_CD
AND DSBLD.LOOKUP_TYPE (+)= 'REGISTERED_DISABLED'
AND CVG_STRT.FORMULA_ID (+)= EDC.CVG_STRT_RL
AND EDC.EFFECTIVE_START_DATE BETWEEN CVG_STRT.EFFECTIVE_START_DATE(+)
AND CVG_STRT.EFFECTIVE_END_DATE(+)
AND CVG_THRU.FORMULA_ID (+)= EDC.CVG_THRU_RL
AND EDC.EFFECTIVE_START_DATE BETWEEN CVG_THRU.EFFECTIVE_START_DATE(+)
AND CVG_THRU.EFFECTIVE_END_DATE(+)

Columns