DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_ENRLD_ANTHR_PTIP_F

Line 11989: from ben_elig_enrld_anthr_ptip_f eet

11985: where p_effective_date
11986: between elp.effective_start_date
11987: and elp.effective_end_date
11988: and exists(select null
11989: from ben_elig_enrld_anthr_ptip_f eet
11990: where p_effective_date
11991: between eet.effective_start_date
11992: and eet.effective_end_date
11993: and eet.eligy_prfl_id = elp.eligy_prfl_id)

Line 12002: from ben_elig_enrld_anthr_ptip_f eet

11998: eet.excld_flag,
11999: eet.enrl_det_dt_cd,
12000: eet.only_pls_subj_cobra_flag,
12001: eet.ptip_id
12002: from ben_elig_enrld_anthr_ptip_f eet
12003: where p_effective_date
12004: between eet.effective_start_date
12005: and eet.effective_end_date
12006: order by eet.eligy_prfl_id,