VIEW: APPS.BEN_DPNT_CVG_RQD_RLSHP_D

Source

View Text - Preformatted

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(+) AND dcr.effective_start_date BETWEEN dpnt_cvg_eligy_prfl.effective_start_date(+) AND dpnt_cvg_eligy_prfl.effective_end_date(+)

View Text - HTML Formatted

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(+)
AND DCR.EFFECTIVE_START_DATE BETWEEN DPNT_CVG_ELIGY_PRFL.EFFECTIVE_START_DATE(+)
AND DPNT_CVG_ELIGY_PRFL.EFFECTIVE_END_DATE(+)