DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_ENRLD_ANTHR_PGM_F

Line 10554: from ben_elig_enrld_anthr_pgm_f eeg

10550: where p_effective_date
10551: between elp.effective_start_date
10552: and elp.effective_end_date
10553: and exists(select null
10554: from ben_elig_enrld_anthr_pgm_f eeg
10555: where p_effective_date
10556: between eeg.effective_start_date
10557: and eeg.effective_end_date
10558: and eeg.eligy_prfl_id = elp.eligy_prfl_id)

Line 10566: from ben_elig_enrld_anthr_pgm_f eeg

10562: select eeg.eligy_prfl_id,
10563: eeg.pgm_id,
10564: eeg.enrl_det_dt_cd,
10565: eeg.excld_flag
10566: from ben_elig_enrld_anthr_pgm_f eeg
10567: where p_effective_date
10568: between eeg.effective_start_date
10569: and eeg.effective_end_date
10570: order by eeg.eligy_prfl_id,