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 2976: FROM ben_elig_per_f ep, ben_elig_per_opt_f epo, ben_per_in_ler pil

2972: SELECT ep.elig_per_id,
2973: epo.elig_flag,
2974: ep.must_enrl_anthr_pl_id,
2975: epo.prtn_strt_dt
2976: FROM ben_elig_per_f ep, ben_elig_per_opt_f epo, ben_per_in_ler pil
2977: WHERE ep.person_id = p_person_id
2978: AND ep.pl_id = l_pl_id
2979: AND (
2980: ( ep.pgm_id = p_pgm_id

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

3000: -- Determines the previous eligibility for an option
3001: --
3002: CURSOR c_previous_elig_for_option IS
3003: SELECT epo.elig_flag
3004: FROM ben_elig_per_f ep, ben_elig_per_opt_f epo, ben_per_in_ler pil
3005: WHERE ep.person_id = p_person_id
3006: AND ep.pl_id = l_pl_id
3007: AND (
3008: ( ep.pgm_id = p_pgm_id

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

9778: -- Determines the previous eligibility for an option
9779: --
9780: CURSOR c_previous_elig_for_option IS
9781: SELECT epo.elig_flag
9782: FROM ben_elig_per_f ep, ben_elig_per_opt_f epo, ben_per_in_ler pil
9783: WHERE ep.person_id = p_person_id
9784: AND ep.pl_id = l_plan_rec.pl_id
9785: AND (
9786: ( ep.pgm_id = l_pgm_rec.pgm_id