DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_ENRLD_ANTHR_OIPL_F

Line 10315: from ben_elig_enrld_anthr_oipl_f eei

10311: where p_effective_date
10312: between elp.effective_start_date
10313: and elp.effective_end_date
10314: and exists(select null
10315: from ben_elig_enrld_anthr_oipl_f eei
10316: where p_effective_date
10317: between eei.effective_start_date
10318: and eei.effective_end_date
10319: and eei.eligy_prfl_id = elp.eligy_prfl_id)

Line 10327: from ben_elig_enrld_anthr_oipl_f eei

10323: select eei.eligy_prfl_id,
10324: eei.oipl_id,
10325: eei.enrl_det_dt_cd,
10326: eei.excld_flag
10327: from ben_elig_enrld_anthr_oipl_f eei
10328: where p_effective_date
10329: between eei.effective_start_date
10330: and eei.effective_end_date
10331: order by eei.eligy_prfl_id,