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)
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,