View: BEN_DPNT_CVG_RQD_RLSHP_D

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

View Text

SELECT DCR.ROWID ROW_ID
, DCR.DPNT_CVG_RQD_RLSHP_ID
, DCR.EFFECTIVE_START_DATE
, DCR.EFFECTIVE_END_DATE
, PER_RELSHP_TYP.MEANING
, CVG_STRT_DT.MEANING
, CVG_THRU_DT2.FORMULA_NAME
, CVG_THRU_DT.MEANING
, CVG_STRT_DT2.FORMULA_NAME
, DPNT_CVG_ELIGY_PRFL.NAME
, DCR.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_DPNT_CVG_RQD_RLSHP_F DCR
, FND_USER FUSER
, BEN_DPNT_CVG_ELIGY_PRFL_F DPNT_CVG_ELIGY_PRFL
, HR_LOOKUPS PER_RELSHP_TYP
, HR_LOOKUPS CVG_STRT_DT
, HR_LOOKUPS CVG_THRU_DT
, FF_FORMULAS_F CVG_THRU_DT2
, FF_FORMULAS_F CVG_STRT_DT2
WHERE FUSER.USER_ID (+)= DCR.LAST_UPDATED_BY
AND DPNT_CVG_ELIGY_PRFL.DPNT_CVG_ELIGY_PRFL_ID (+)= DCR.DPNT_CVG_ELIGY_PRFL_ID
AND PER_RELSHP_TYP.LOOKUP_CODE (+)= DCR.PER_RELSHP_TYP_CD
AND PER_RELSHP_TYP.LOOKUP_TYPE (+)= 'CONTACT'
AND CVG_STRT_DT.LOOKUP_CODE (+)= DCR.CVG_STRT_DT_CD
AND CVG_STRT_DT.LOOKUP_TYPE (+)= 'BEN_DPNT_CVG_STRT'
AND CVG_THRU_DT.LOOKUP_CODE (+)= DCR.CVG_THRU_DT_CD
AND CVG_THRU_DT.LOOKUP_TYPE (+)= 'BEN_DPNT_CVG_END'
AND CVG_THRU_DT2.FORMULA_ID (+)= DCR.CVG_THRU_DT_RL
AND DCR.EFFECTIVE_START_DATE BETWEEN CVG_THRU_DT2.EFFECTIVE_START_DATE(+)
AND CVG_THRU_DT2.EFFECTIVE_END_DATE(+)
AND CVG_STRT_DT2.FORMULA_ID (+)= DCR.CVG_STRT_DT_RL
AND DCR.EFFECTIVE_START_DATE BETWEEN CVG_STRT_DT2.EFFECTIVE_START_DATE(+)
AND CVG_STRT_DT2.EFFECTIVE_END_DATE(+)

Columns