APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_LER_F

Line 2337: ,ben_ler_f ler

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
2340: and ler.typ_cd not in ('COMP','ABS', 'GSP', 'IREC','SCHEDDU')
2341: and l_lf_evt_ocrd_dt between

Line 2351: ,ben_ler_f ler

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
2354: AND pil.ler_id = ler.ler_id
2355: and ler.typ_cd not in ('COMP','ABS', 'GSP', 'IREC','SCHEDDU')

Line 2376: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler

2372: --however he wanted this to be removed so that self service open enrollment
2373: --will not be impacted and asked find ways to show history on enrollment results later
2374: cursor c_get_latest_enrt_dt is
2375: select max(rslt.effective_start_date)
2376: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler
2377: where rslt.person_id = p_person_id
2378: and ler.ler_id=rslt.ler_id
2379: -- and rslt.prtt_enrt_rslt_stat_cd NOT IN ('BCKDT', 'VOIDD')
2380: and rslt.prtt_enrt_rslt_stat_cd is null

Line 2567: l_ler_name ben_ler_f.name%TYPE;

2563: l_pl_id NUMBER;
2564: l_prereq_electable_flag VARCHAR2(30);
2565: l_oipl_name ben_opt_f.name%TYPE;
2566: l_pl_name ben_pl_f.name%TYPE;
2567: l_ler_name ben_ler_f.name%TYPE;
2568: l_must_enrl_anthr_pl_id NUMBER;
2569: l_auto_enrt_flag VARCHAR2(30) := 'N';
2570: l_rec_auto_enrt_flag VARCHAR2(30) := 'N';
2571: l_comp_lvl_cd VARCHAR2(30);

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 3190: ben_ler_f ler

3186: /* bug 2746865 */
3187: enrtp.enrt_perd_det_ovrlp_bckdt_cd
3188: FROM ben_popl_enrt_typ_cycl_f petc,
3189: ben_enrt_perd enrtp,
3190: ben_ler_f ler
3191: WHERE petc.pl_id = l_pl_id
3192: AND petc.business_group_id = p_business_group_id
3193: AND l_lf_evt_ocrd_dt BETWEEN petc.effective_start_date
3194: AND petc.effective_end_date

Line 3229: ben_ler_f ler

3225: /* bug 2746865*/
3226: enrtp.enrt_perd_det_ovrlp_bckdt_cd
3227: FROM ben_popl_enrt_typ_cycl_f petc,
3228: ben_enrt_perd enrtp,
3229: ben_ler_f ler
3230: WHERE petc.pgm_id = p_pgm_id
3231: AND petc.business_group_id = p_business_group_id
3232: AND l_lf_evt_ocrd_dt BETWEEN petc.effective_start_date
3233: AND petc.effective_end_date

Line 3600: from ben_ler_f ler

3596: ;
3597: --
3598: cursor c_ler_requery(p_id number,p_ed date) is
3599: select 'Y'
3600: from ben_ler_f ler
3601: where ler_id=p_id and
3602: business_group_id=p_business_group_id and
3603: p_ed between effective_start_date and effective_end_date
3604: ;