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 2308: FROM ben_per_in_ler pil

2304: l_sysdate date := trunc(sysdate);
2305: -- define cursors
2306: CURSOR c_get_latest_procd_dt IS
2307: SELECT MAX(pil.procd_dt)
2308: FROM ben_per_in_ler pil
2309: -- CWB changes
2310: ,ben_ler_f ler
2311: WHERE pil.person_id = p_person_id
2312: AND pil.ler_id = ler.ler_id

Line 2322: FROM ben_per_in_ler pil

2318: AND pil.procd_dt IS NOT NULL;
2319: --
2320: CURSOR c_backed_out_ler IS
2321: SELECT MAX(pil.bckt_dt)
2322: FROM ben_per_in_ler pil
2323: -- CWB changes
2324: ,ben_ler_f ler
2325: ,ben_ptnl_ler_for_per plr
2326: WHERE pil.person_id = p_person_id

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

3086: ler.name,
3087: pil.lf_evt_ocrd_dt,
3088: ler.effective_start_date,
3089: ler.effective_end_date
3090: FROM ben_per_in_ler pil, ben_ler_f ler
3091: WHERE pil.person_id = p_person_id
3092: AND pil.business_group_id = p_business_group_id
3093: AND pil.ler_id = p_ler_id
3094: AND pil.per_in_ler_stat_cd = 'STRTD'

Line 3113: FROM ben_per_in_ler pil, ben_ler_f ler

3109: ler.name,
3110: pil.lf_evt_ocrd_dt,
3111: ler.effective_start_date,
3112: ler.effective_end_date
3113: FROM ben_per_in_ler pil, ben_ler_f ler
3114: WHERE pil.per_in_ler_id = p_per_in_ler_id
3115: AND pil.business_group_id = p_business_group_id
3116: -- AND pil.ler_id = p_ler_id
3117: -- AND pil.per_in_ler_stat_cd = 'STRTD'

Line 9589: ben_per_in_ler pil,

9585: epe.ELIG_PER_ELCTBL_CHC_ID,
9586: epe.OBJECT_VERSION_NUMBER
9587: from ben_elig_per_elctbl_chc epe,
9588: /*
9589: ben_per_in_ler pil,
9590: */
9591: ben_pl_f pln
9592: where epe.auto_enrt_flag = 'N'
9593: and epe.per_in_ler_id = c_per_in_ler_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

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

Line 9847: FROM ben_elig_dpnt egd, ben_per_in_ler pil

9843: -- 5092244
9844: CURSOR c_elig_dpnt (v_epe_id NUMBER)
9845: IS
9846: SELECT egd.elig_dpnt_id, egd.object_version_number
9847: FROM ben_elig_dpnt egd, ben_per_in_ler pil
9848: WHERE elig_per_elctbl_chc_id = v_epe_id
9849: AND pil.per_in_ler_id = egd.per_in_ler_id
9850: AND pil.per_in_ler_stat_cd = 'STRTD';
9851: