DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_ENRLD_ANTHR_PLIP_F

Line 11853: from ben_elig_enrld_anthr_plip_f eai

11849: where p_effective_date
11850: between elp.effective_start_date
11851: and elp.effective_end_date
11852: and exists(select null
11853: from ben_elig_enrld_anthr_plip_f eai
11854: where p_effective_date
11855: between eai.effective_start_date
11856: and eai.effective_end_date
11857: and eai.eligy_prfl_id = elp.eligy_prfl_id)

Line 11865: from ben_elig_enrld_anthr_plip_f eai

11861: select eai.eligy_prfl_id,
11862: eai.enrl_det_dt_cd,
11863: eai.plip_id,
11864: eai.excld_flag
11865: from ben_elig_enrld_anthr_plip_f eai
11866: where p_effective_date
11867: between eai.effective_start_date
11868: and eai.effective_end_date
11869: order by eai.eligy_prfl_id,