APPS.BEN_ENROLMENT_REQUIREMENTS1 dependencies on BEN_PER_IN_LER

Line 523: FROM ben_per_in_ler pil

519: l_sysdate date := trunc(sysdate);
520: -- define cursors
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

Line 537: FROM ben_per_in_ler pil

533: AND pil.procd_dt IS NOT NULL;
534: --
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