APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_ELIG_PER_F

Line 66: Check pgm_id on all ben_elig_per_f sql

62: Support for unrestricted enrt.
63: Removed all rt_strt_dt logic.
64: use enrt_perd_for_pl_f for csd calc.
65: 28 Oct 98 jcarpent 115.27 Set l_rec_cls_enrt_dt_to_use_cd
66: Check pgm_id on all ben_elig_per_f sql
67: 28 Oct 98 G Perry 115.28 Fixed all ben_elig_per_f references in
68: cursors as they were all ropey.
69: 30 Oct 98 G Perry 115.30 Fixed how parameter
70: popl_enrt_typ_cycl_id works to support

Line 67: 28 Oct 98 G Perry 115.28 Fixed all ben_elig_per_f references in

63: Removed all rt_strt_dt logic.
64: use enrt_perd_for_pl_f for csd calc.
65: 28 Oct 98 jcarpent 115.27 Set l_rec_cls_enrt_dt_to_use_cd
66: Check pgm_id on all ben_elig_per_f sql
67: 28 Oct 98 G Perry 115.28 Fixed all ben_elig_per_f references in
68: cursors as they were all ropey.
69: 30 Oct 98 G Perry 115.30 Fixed how parameter
70: popl_enrt_typ_cycl_id works to support
71: multiple scheduled enrollment.

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 3038: FROM ben_elig_per_f pep, ben_per_in_ler pil

3034: pep.elig_flag,
3035: pep.must_enrl_anthr_pl_id,
3036: pep.prtn_strt_dt,
3037: pep.inelg_rsn_cd -- 2650247
3038: FROM ben_elig_per_f pep, ben_per_in_ler pil
3039: WHERE pep.person_id = p_person_id
3040: AND pep.pl_id = l_pl_id
3041: AND (
3042: ( pep.pgm_id = p_pgm_id

Line 3062: FROM ben_elig_per_f pep, ben_per_in_ler pil

3058: -- Determines the previous eligibility for a plan
3059: --
3060: CURSOR c_previous_elig_for_plan IS
3061: SELECT pep.elig_flag
3062: FROM ben_elig_per_f pep, ben_per_in_ler pil
3063: WHERE pep.person_id = p_person_id
3064: AND pep.pl_id = l_pl_id
3065: AND (
3066: ( pep.pgm_id = p_pgm_id

Line 3598: l_inelg_rsn_cd ben_elig_per_f.inelg_rsn_cd%type; -- 2650247

3594: --
3595: -- CWB Chnages.
3596: --
3597: l_emp_epe_id number;
3598: l_inelg_rsn_cd ben_elig_per_f.inelg_rsn_cd%type; -- 2650247
3599:
3600: -- CWBITEM
3601: l_emp_pel_id number;
3602: l_pel_id number;

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

Line 9810: FROM ben_elig_per_f pep, ben_per_in_ler pil

9806: -- Determines the previous eligibility for a plan
9807: --
9808: CURSOR c_previous_elig_for_plan IS
9809: SELECT pep.elig_flag
9810: FROM ben_elig_per_f pep, ben_per_in_ler pil
9811: WHERE pep.person_id = p_person_id
9812: AND pep.pl_id = l_plan_rec.pl_id
9813: AND (
9814: ( pep.pgm_id = l_pgm_rec.pgm_id