APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_PTNL_LER_FOR_PER

Line 2352: ,ben_ptnl_ler_for_per plr

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')
2356: and l_lf_evt_ocrd_dt between