APPS.BEN_ENROLMENT_REQUIREMENTS1 dependencies on BEN_LER_F

Line 450: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler

446: is
447: select /*+ c_getpenesd ben_enrolment_requirements1 */
448: rslt.effective_start_date,
449: rslt.enrt_cvg_thru_dt
450: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler
451: where rslt.person_id = c_per_id
452: and ler.ler_id=rslt.ler_id
453: and rslt.prtt_enrt_rslt_stat_cd is null
454: and ler.typ_cd not in ('COMP','ABS', 'GSP', 'IREC','SCHEDDU' )

Line 525: ,ben_ler_f ler

521: CURSOR c_get_latest_procd_dt IS
522: SELECT MAX(pil.procd_dt)
523: FROM ben_per_in_ler pil
524: -- CWB changes
525: ,ben_ler_f ler
526: WHERE pil.person_id = p_person_id
527: AND pil.ler_id = ler.ler_id
528: and ler.typ_cd not in ('COMP','ABS', 'GSP', 'IREC','SCHEDDU')
529: and l_lf_evt_ocrd_dt between

Line 539: ,ben_ler_f ler

535: CURSOR c_backed_out_ler IS
536: SELECT MAX(pil.bckt_dt)
537: FROM ben_per_in_ler pil
538: -- CWB changes
539: ,ben_ler_f ler
540: ,ben_ptnl_ler_for_per plr
541: WHERE pil.person_id = p_person_id
542: AND pil.ler_id = ler.ler_id
543: and ler.typ_cd not in ('COMP','ABS', 'GSP', 'IREC','SCHEDDU')

Line 564: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler

560: --however he wanted this to be removed so that self service open enrollment
561: --will not be impacted and asked find ways to show history on enrollment results later
562: cursor c_get_latest_enrt_dt is
563: select max(rslt.effective_start_date)
564: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler
565: where rslt.person_id = p_person_id
566: and ler.ler_id=rslt.ler_id
567: -- and rslt.prtt_enrt_rslt_stat_cd NOT IN ('BCKDT', 'VOIDD')
568: and rslt.prtt_enrt_rslt_stat_cd is null