APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_LER_F

Line 2310: ,ben_ler_f ler

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

Line 2324: ,ben_ler_f ler

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

Line 2349: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler

2345: --however he wanted this to be removed so that self service open enrollment
2346: --will not be impacted and asked find ways to show history on enrollment results later
2347: cursor c_get_latest_enrt_dt is
2348: select max(rslt.effective_start_date)
2349: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler
2350: where rslt.person_id = p_person_id
2351: and ler.ler_id=rslt.ler_id
2352: -- and rslt.prtt_enrt_rslt_stat_cd NOT IN ('BCKDT', 'VOIDD')
2353: and rslt.prtt_enrt_rslt_stat_cd is null

Line 2540: l_ler_name ben_ler_f.name%TYPE;

2536: l_pl_id NUMBER;
2537: l_prereq_electable_flag VARCHAR2(30);
2538: l_oipl_name ben_opt_f.name%TYPE;
2539: l_pl_name ben_pl_f.name%TYPE;
2540: l_ler_name ben_ler_f.name%TYPE;
2541: l_must_enrl_anthr_pl_id NUMBER;
2542: l_auto_enrt_flag VARCHAR2(30) := 'N';
2543: l_rec_auto_enrt_flag VARCHAR2(30) := 'N';
2544: l_comp_lvl_cd VARCHAR2(30);

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

3140: /* bug 2746865 */
3141: enrtp.enrt_perd_det_ovrlp_bckdt_cd
3142: FROM ben_popl_enrt_typ_cycl_f petc,
3143: ben_enrt_perd enrtp,
3144: ben_ler_f ler
3145: WHERE petc.pl_id = l_pl_id
3146: AND petc.business_group_id = p_business_group_id
3147: AND l_lf_evt_ocrd_dt BETWEEN petc.effective_start_date
3148: AND petc.effective_end_date

Line 3183: ben_ler_f ler

3179: /* bug 2746865*/
3180: enrtp.enrt_perd_det_ovrlp_bckdt_cd
3181: FROM ben_popl_enrt_typ_cycl_f petc,
3182: ben_enrt_perd enrtp,
3183: ben_ler_f ler
3184: WHERE petc.pgm_id = p_pgm_id
3185: AND petc.business_group_id = p_business_group_id
3186: AND l_lf_evt_ocrd_dt BETWEEN petc.effective_start_date
3187: AND petc.effective_end_date

Line 3554: from ben_ler_f ler

3550: ;
3551: --
3552: cursor c_ler_requery(p_id number,p_ed date) is
3553: select 'Y'
3554: from ben_ler_f ler
3555: where ler_id=p_id and
3556: business_group_id=p_business_group_id and
3557: p_ed between effective_start_date and effective_end_date
3558: ;