VIEW: APPS.BEN_ELIG_AGE_CVG_D

Source

View Text - Preformatted

SELECT EAC.ROWID ROW_ID , EAC.ELIG_AGE_CVG_ID , EAC.EFFECTIVE_START_DATE , EAC.EFFECTIVE_END_DATE , DPNT_CVG_ELIGY_PRFL.NAME , AGE_FCTR.NAME , CVG_STRT.MEANING , CVG_STRT2.FORMULA_NAME , CVG_THRU.MEANING , CVG_THRU2.FORMULA_NAME , EXCLD.MEANING , EAC.LAST_UPDATE_DATE , FUSER.LAST_UPDATED_BY FROM BEN_ELIG_AGE_CVG_F EAC, FND_USER FUSER ,BEN_DPNT_CVG_ELIGY_PRFL_F DPNT_CVG_ELIGY_PRFL ,BEN_AGE_FCTR AGE_FCTR ,HR_LOOKUPS CVG_STRT ,HR_LOOKUPS CVG_THRU ,HR_LOOKUPS EXCLD ,FF_FORMULAS_F CVG_STRT2 ,FF_FORMULAS_F CVG_THRU2 WHERE FUSER.USER_ID (+)= EAC.LAST_UPDATED_BY AND DPNT_CVG_ELIGY_PRFL.DPNT_CVG_ELIGY_PRFL_ID (+)= EAC.DPNT_CVG_ELIGY_PRFL_ID AND AGE_FCTR.AGE_FCTR_ID (+)= EAC.AGE_FCTR_ID AND CVG_STRT.LOOKUP_CODE (+)= EAC.CVG_STRT_CD AND CVG_STRT.LOOKUP_TYPE (+)= 'BEN_DPNT_CVG_STRT' AND CVG_THRU.LOOKUP_CODE (+)= EAC.CVG_THRU_CD AND CVG_THRU.LOOKUP_TYPE (+)= 'BEN_DPNT_CVG_END' AND EXCLD.LOOKUP_CODE (+)= EAC.EXCLD_FLAG AND EXCLD.LOOKUP_TYPE (+)= 'YES_NO' AND CVG_STRT2.FORMULA_ID (+)= EAC.CVG_STRT_RL AND EAC.EFFECTIVE_START_DATE BETWEEN CVG_STRT2.EFFECTIVE_START_DATE(+) AND CVG_STRT2.EFFECTIVE_END_DATE(+) AND CVG_THRU2.FORMULA_ID (+)= EAC.CVG_THRU_RL AND EAC.EFFECTIVE_START_DATE BETWEEN CVG_THRU2.EFFECTIVE_START_DATE(+) AND CVG_THRU2.EFFECTIVE_END_DATE(+) AND eac.effective_start_date BETWEEN dpnt_cvg_eligy_prfl.effective_start_date(+) AND dpnt_cvg_eligy_prfl.effective_end_date(+)

View Text - HTML Formatted

SELECT EAC.ROWID ROW_ID
, EAC.ELIG_AGE_CVG_ID
, EAC.EFFECTIVE_START_DATE
, EAC.EFFECTIVE_END_DATE
, DPNT_CVG_ELIGY_PRFL.NAME
, AGE_FCTR.NAME
, CVG_STRT.MEANING
, CVG_STRT2.FORMULA_NAME
, CVG_THRU.MEANING
, CVG_THRU2.FORMULA_NAME
, EXCLD.MEANING
, EAC.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_ELIG_AGE_CVG_F EAC
, FND_USER FUSER
, BEN_DPNT_CVG_ELIGY_PRFL_F DPNT_CVG_ELIGY_PRFL
, BEN_AGE_FCTR AGE_FCTR
, HR_LOOKUPS CVG_STRT
, HR_LOOKUPS CVG_THRU
, HR_LOOKUPS EXCLD
, FF_FORMULAS_F CVG_STRT2
, FF_FORMULAS_F CVG_THRU2
WHERE FUSER.USER_ID (+)= EAC.LAST_UPDATED_BY
AND DPNT_CVG_ELIGY_PRFL.DPNT_CVG_ELIGY_PRFL_ID (+)= EAC.DPNT_CVG_ELIGY_PRFL_ID
AND AGE_FCTR.AGE_FCTR_ID (+)= EAC.AGE_FCTR_ID
AND CVG_STRT.LOOKUP_CODE (+)= EAC.CVG_STRT_CD
AND CVG_STRT.LOOKUP_TYPE (+)= 'BEN_DPNT_CVG_STRT'
AND CVG_THRU.LOOKUP_CODE (+)= EAC.CVG_THRU_CD
AND CVG_THRU.LOOKUP_TYPE (+)= 'BEN_DPNT_CVG_END'
AND EXCLD.LOOKUP_CODE (+)= EAC.EXCLD_FLAG
AND EXCLD.LOOKUP_TYPE (+)= 'YES_NO'
AND CVG_STRT2.FORMULA_ID (+)= EAC.CVG_STRT_RL
AND EAC.EFFECTIVE_START_DATE BETWEEN CVG_STRT2.EFFECTIVE_START_DATE(+)
AND CVG_STRT2.EFFECTIVE_END_DATE(+)
AND CVG_THRU2.FORMULA_ID (+)= EAC.CVG_THRU_RL
AND EAC.EFFECTIVE_START_DATE BETWEEN CVG_THRU2.EFFECTIVE_START_DATE(+)
AND CVG_THRU2.EFFECTIVE_END_DATE(+)
AND EAC.EFFECTIVE_START_DATE BETWEEN DPNT_CVG_ELIGY_PRFL.EFFECTIVE_START_DATE(+)
AND DPNT_CVG_ELIGY_PRFL.EFFECTIVE_END_DATE(+)