DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_ENRLD_ANTHR_OIPL_F

Line 10610: from ben_elig_enrld_anthr_oipl_f eei

10606: where p_effective_date
10607: between elp.effective_start_date
10608: and elp.effective_end_date
10609: and exists(select null
10610: from ben_elig_enrld_anthr_oipl_f eei
10611: where p_effective_date
10612: between eei.effective_start_date
10613: and eei.effective_end_date
10614: and eei.eligy_prfl_id = elp.eligy_prfl_id)

Line 10622: from ben_elig_enrld_anthr_oipl_f eei

10618: select eei.eligy_prfl_id,
10619: eei.oipl_id,
10620: eei.enrl_det_dt_cd,
10621: eei.excld_flag
10622: from ben_elig_enrld_anthr_oipl_f eei
10623: where p_effective_date
10624: between eei.effective_start_date
10625: and eei.effective_end_date
10626: order by eei.eligy_prfl_id,