VIEW: APPS.BEN_APLD_DPNT_CVG_ELIG_PRFL_D

Source

View Text - Preformatted

SELECT ade.rowid row_id, ade.apld_dpnt_cvg_elig_prfl_id, ade.effective_start_date, ade.effective_end_date, ff.formula_name, ade.mndtry_flag, pln.name, pgm.name, dce1.name, ade.last_update_date, fuser.user_name from ben_apld_dpnt_cvg_elig_prfl_f ade, fnd_user fuser, ben_dpnt_cvg_eligy_prfl_f dce1, ff_formulas_f ff, ben_pl_f pln, ben_pgm_f pgm, ben_ptip_f ctp WHERE fuser.user_id(+) = ade.last_updated_by and dce1.dpnt_cvg_eligy_prfl_id(+)=ade.dpnt_cvg_eligy_prfl_id and ff.formula_id(+)=ade.apld_dpnt_cvg_elig_rl and pln.pl_id(+)=ade.pl_id and pgm.pgm_id(+)=ade.pgm_id and ctp.ptip_id(+)=ade.ptip_id and ade.dpnt_cvg_eligy_prfl_id=dce1.dpnt_cvg_eligy_prfl_id(+) and ade.effective_start_date BETWEEN ff.effective_start_date(+) and ff.effective_end_date(+) and ade.effective_start_date BETWEEN dce1.effective_start_date(+) and dce1.effective_end_date(+) and ade.effective_start_date BETWEEN pln.effective_start_date(+) and pln.effective_end_date(+) and ade.effective_start_date BETWEEN pgm.effective_start_date(+) and pgm.effective_end_date(+) and ade.effective_start_date BETWEEN ctp.effective_start_date(+) and ctp.effective_end_date(+)

View Text - HTML Formatted

SELECT ADE.ROWID ROW_ID
, ADE.APLD_DPNT_CVG_ELIG_PRFL_ID
, ADE.EFFECTIVE_START_DATE
, ADE.EFFECTIVE_END_DATE
, FF.FORMULA_NAME
, ADE.MNDTRY_FLAG
, PLN.NAME
, PGM.NAME
, DCE1.NAME
, ADE.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_APLD_DPNT_CVG_ELIG_PRFL_F ADE
, FND_USER FUSER
, BEN_DPNT_CVG_ELIGY_PRFL_F DCE1
, FF_FORMULAS_F FF
, BEN_PL_F PLN
, BEN_PGM_F PGM
, BEN_PTIP_F CTP
WHERE FUSER.USER_ID(+) = ADE.LAST_UPDATED_BY
AND DCE1.DPNT_CVG_ELIGY_PRFL_ID(+)=ADE.DPNT_CVG_ELIGY_PRFL_ID
AND FF.FORMULA_ID(+)=ADE.APLD_DPNT_CVG_ELIG_RL
AND PLN.PL_ID(+)=ADE.PL_ID
AND PGM.PGM_ID(+)=ADE.PGM_ID
AND CTP.PTIP_ID(+)=ADE.PTIP_ID
AND ADE.DPNT_CVG_ELIGY_PRFL_ID=DCE1.DPNT_CVG_ELIGY_PRFL_ID(+)
AND ADE.EFFECTIVE_START_DATE BETWEEN FF.EFFECTIVE_START_DATE(+)
AND FF.EFFECTIVE_END_DATE(+)
AND ADE.EFFECTIVE_START_DATE BETWEEN DCE1.EFFECTIVE_START_DATE(+)
AND DCE1.EFFECTIVE_END_DATE(+)
AND ADE.EFFECTIVE_START_DATE BETWEEN PLN.EFFECTIVE_START_DATE(+)
AND PLN.EFFECTIVE_END_DATE(+)
AND ADE.EFFECTIVE_START_DATE BETWEEN PGM.EFFECTIVE_START_DATE(+)
AND PGM.EFFECTIVE_END_DATE(+)
AND ADE.EFFECTIVE_START_DATE BETWEEN CTP.EFFECTIVE_START_DATE(+)
AND CTP.EFFECTIVE_END_DATE(+)