DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_ENRLD_ANTHR_PGM_F

Line 10858: from ben_elig_enrld_anthr_pgm_f eeg

10854: where p_effective_date
10855: between elp.effective_start_date
10856: and elp.effective_end_date
10857: and exists(select null
10858: from ben_elig_enrld_anthr_pgm_f eeg
10859: where p_effective_date
10860: between eeg.effective_start_date
10861: and eeg.effective_end_date
10862: and eeg.eligy_prfl_id = elp.eligy_prfl_id)

Line 10870: from ben_elig_enrld_anthr_pgm_f eeg

10866: select eeg.eligy_prfl_id,
10867: eeg.pgm_id,
10868: eeg.enrl_det_dt_cd,
10869: eeg.excld_flag
10870: from ben_elig_enrld_anthr_pgm_f eeg
10871: where p_effective_date
10872: between eeg.effective_start_date
10873: and eeg.effective_end_date
10874: order by eeg.eligy_prfl_id,