eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_ELIG_PER_OPT_F

Line 3022: FROM ben_elig_per_f ep, ben_elig_per_opt_f epo, ben_per_in_ler pil

3018: SELECT ep.elig_per_id,
3019: epo.elig_flag,
3020: ep.must_enrl_anthr_pl_id,
3021: epo.prtn_strt_dt
3022: FROM ben_elig_per_f ep, ben_elig_per_opt_f epo, ben_per_in_ler pil
3023: WHERE ep.person_id = p_person_id
3024: AND ep.pl_id = l_pl_id
3025: AND (
3026: ( ep.pgm_id = p_pgm_id

Line 3050: FROM ben_elig_per_f ep, ben_elig_per_opt_f epo, ben_per_in_ler pil

3046: -- Determines the previous eligibility for an option
3047: --
3048: CURSOR c_previous_elig_for_option IS
3049: SELECT epo.elig_flag
3050: FROM ben_elig_per_f ep, ben_elig_per_opt_f epo, ben_per_in_ler pil
3051: WHERE ep.person_id = p_person_id
3052: AND ep.pl_id = l_pl_id
3053: AND (
3054: ( ep.pgm_id = p_pgm_id

Line 9924: FROM ben_elig_per_f ep, ben_elig_per_opt_f epo, ben_per_in_ler pil

9920: -- Determines the previous eligibility for an option
9921: --
9922: CURSOR c_previous_elig_for_option IS
9923: SELECT epo.elig_flag
9924: FROM ben_elig_per_f ep, ben_elig_per_opt_f epo, ben_per_in_ler pil
9925: WHERE ep.person_id = p_person_id
9926: AND ep.pl_id = l_plan_rec.pl_id
9927: AND (
9928: ( ep.pgm_id = l_pgm_rec.pgm_id