DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_ENRLD_ANTHR_PL_F

Line 10362: from ben_elig_enrld_anthr_pl_f eep

10358: where p_effective_date
10359: between elp.effective_start_date
10360: and elp.effective_end_date
10361: and exists(select null
10362: from ben_elig_enrld_anthr_pl_f eep
10363: where p_effective_date
10364: between eep.effective_start_date
10365: and eep.effective_end_date
10366: and eep.eligy_prfl_id = elp.eligy_prfl_id)

Line 10374: from ben_elig_enrld_anthr_pl_f eep

10370: select eep.eligy_prfl_id,
10371: eep.pl_id,
10372: eep.enrl_det_dt_cd,
10373: eep.excld_flag
10374: from ben_elig_enrld_anthr_pl_f eep
10375: where p_effective_date
10376: between eep.effective_start_date
10377: and eep.effective_end_date
10378: order by eep.eligy_prfl_id,