DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_ENRLD_ANTHR_PLIP_F

Line 11513: from ben_elig_enrld_anthr_plip_f eai

11509: where p_effective_date
11510: between elp.effective_start_date
11511: and elp.effective_end_date
11512: and exists(select null
11513: from ben_elig_enrld_anthr_plip_f eai
11514: where p_effective_date
11515: between eai.effective_start_date
11516: and eai.effective_end_date
11517: and eai.eligy_prfl_id = elp.eligy_prfl_id)

Line 11525: from ben_elig_enrld_anthr_plip_f eai

11521: select eai.eligy_prfl_id,
11522: eai.enrl_det_dt_cd,
11523: eai.plip_id,
11524: eai.excld_flag
11525: from ben_elig_enrld_anthr_plip_f eai
11526: where p_effective_date
11527: between eai.effective_start_date
11528: and eai.effective_end_date
11529: order by eai.eligy_prfl_id,