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

3080: pep.elig_flag,
3081: pep.must_enrl_anthr_pl_id,
3082: pep.prtn_strt_dt,
3083: pep.inelg_rsn_cd -- 2650247
3084: FROM ben_elig_per_f pep, ben_per_in_ler pil
3085: WHERE pep.person_id = p_person_id
3086: AND pep.pl_id = l_pl_id
3087: AND (
3088: ( pep.pgm_id = p_pgm_id

Line 3108: FROM ben_elig_per_f pep, ben_per_in_ler pil

3104: -- Determines the previous eligibility for a plan
3105: --
3106: CURSOR c_previous_elig_for_plan IS
3107: SELECT pep.elig_flag
3108: FROM ben_elig_per_f pep, ben_per_in_ler pil
3109: WHERE pep.person_id = p_person_id
3110: AND pep.pl_id = l_pl_id
3111: AND (
3112: ( pep.pgm_id = p_pgm_id

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

3640: --
3641: -- CWB Chnages.
3642: --
3643: l_emp_epe_id number;
3644: l_inelg_rsn_cd ben_elig_per_f.inelg_rsn_cd%type; -- 2650247
3645:
3646: -- CWBITEM
3647: l_emp_pel_id number;
3648: l_pel_id number;

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

Line 9952: FROM ben_elig_per_f pep, ben_per_in_ler pil

9948: -- Determines the previous eligibility for a plan
9949: --
9950: CURSOR c_previous_elig_for_plan IS
9951: SELECT pep.elig_flag
9952: FROM ben_elig_per_f pep, ben_per_in_ler pil
9953: WHERE pep.person_id = p_person_id
9954: AND pep.pl_id = l_plan_rec.pl_id
9955: AND (
9956: ( pep.pgm_id = l_pgm_rec.pgm_id