APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_PER_IN_LER

Line 93: 09 Apr 99 stee 115.44 Change ben_per_in_ler_f to

89: Get erlst_deenrt_dt from opt,pl,oipl too
90: 25 Mar 99 jcarpent 115.42 Added assignment_id to rule contexts
91: 01 Apr 99 jcarpent 115.43 Remove exit point when currently enrd,
92: no dpnt chg allowed, not electable.
93: 09 Apr 99 stee 115.44 Change ben_per_in_ler_f to
94: ben_per_in_ler.
95: 28 Apr 99 shdas 115.45 Added more contexts in rule calls.
96: 28 Apr 99 jcarpent 115.46 When no lee_rsn exists exist don't error
97: exit without creating choice.

Line 94: ben_per_in_ler.

90: 25 Mar 99 jcarpent 115.42 Added assignment_id to rule contexts
91: 01 Apr 99 jcarpent 115.43 Remove exit point when currently enrd,
92: no dpnt chg allowed, not electable.
93: 09 Apr 99 stee 115.44 Change ben_per_in_ler_f to
94: ben_per_in_ler.
95: 28 Apr 99 shdas 115.45 Added more contexts in rule calls.
96: 28 Apr 99 jcarpent 115.46 When no lee_rsn exists exist don't error
97: exit without creating choice.
98: 28 Apr 99 jcarpent 115.47 Init perd_for_pgm_found to 'N'

Line 451: population to benptnle (on to ben_per_in_ler)

447: related changes in benbolfe , benelinf ,benleclr
448: 11-oct-03 hmani 115.199 reversing the change done in 115.197. Changing the flag again.
449: 18-Nov-03 tjesumic 115.200 # 3248770 Voided per in ler is not considered to find the enrollment period date
450: 14-Jan-04 pbodla 115.201 GLOBALCWB : moved the heirarchy data
451: population to benptnle (on to ben_per_in_ler)
452: 15-Mar-04 pbodla 115.202 GLOBALCWB : Bug 3502094 : For FP-F trk
453: inelig flag do not have any significance.
454: For july FP : final functionality will be
455: decided later.

Line 2335: FROM ben_per_in_ler pil

2331: l_sysdate date := trunc(sysdate);
2332: -- define cursors
2333: CURSOR c_get_latest_procd_dt IS
2334: SELECT MAX(pil.procd_dt)
2335: FROM ben_per_in_ler pil
2336: -- CWB changes
2337: ,ben_ler_f ler
2338: WHERE pil.person_id = p_person_id
2339: AND pil.ler_id = ler.ler_id

Line 2349: FROM ben_per_in_ler pil

2345: AND pil.procd_dt IS NOT NULL;
2346: --
2347: CURSOR c_backed_out_ler IS
2348: SELECT MAX(pil.bckt_dt)
2349: FROM ben_per_in_ler pil
2350: -- CWB changes
2351: ,ben_ler_f ler
2352: ,ben_ptnl_ler_for_per plr
2353: WHERE pil.person_id = p_person_id

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 3136: FROM ben_per_in_ler pil, ben_ler_f ler

3132: ler.name,
3133: pil.lf_evt_ocrd_dt,
3134: ler.effective_start_date,
3135: ler.effective_end_date
3136: FROM ben_per_in_ler pil, ben_ler_f ler
3137: WHERE pil.person_id = p_person_id
3138: AND pil.business_group_id = p_business_group_id
3139: AND pil.ler_id = p_ler_id
3140: AND pil.per_in_ler_stat_cd = 'STRTD'

Line 3159: FROM ben_per_in_ler pil, ben_ler_f ler

3155: ler.name,
3156: pil.lf_evt_ocrd_dt,
3157: ler.effective_start_date,
3158: ler.effective_end_date
3159: FROM ben_per_in_ler pil, ben_ler_f ler
3160: WHERE pil.per_in_ler_id = p_per_in_ler_id
3161: AND pil.business_group_id = p_business_group_id
3162: -- AND pil.ler_id = p_ler_id
3163: -- AND pil.per_in_ler_stat_cd = 'STRTD'

Line 9731: ben_per_in_ler pil,

9727: epe.ELIG_PER_ELCTBL_CHC_ID,
9728: epe.OBJECT_VERSION_NUMBER
9729: from ben_elig_per_elctbl_chc epe,
9730: /*
9731: ben_per_in_ler pil,
9732: */
9733: ben_pl_f pln
9734: where epe.auto_enrt_flag = 'N'
9735: and epe.per_in_ler_id = c_per_in_ler_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

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

Line 9989: FROM ben_elig_dpnt egd, ben_per_in_ler pil

9985: -- 5092244
9986: CURSOR c_elig_dpnt (v_epe_id NUMBER)
9987: IS
9988: SELECT egd.elig_dpnt_id, egd.object_version_number
9989: FROM ben_elig_dpnt egd, ben_per_in_ler pil
9990: WHERE elig_per_elctbl_chc_id = v_epe_id
9991: AND pil.per_in_ler_id = egd.per_in_ler_id
9992: AND pil.per_in_ler_stat_cd = 'STRTD';
9993: