APPS.BEN_REOPEN_LER_CONC dependencies on BEN_LER_F

Line 90: FROM per_all_people_f per, ben_per_in_ler pil, ben_ler_f ler

86: -- latest or not at the time reopening life event api
87: CURSOR c_pil
88: IS
89: SELECT per.person_id, pil.per_in_ler_id
90: FROM per_all_people_f per, ben_per_in_ler pil, ben_ler_f ler
91: WHERE pil.person_id = per.person_id
92: AND pil.per_in_ler_stat_cd = 'PROCD'
93: AND pil.ler_id = p_ler_id
94: AND pil.ler_id = ler.ler_id

Line 604: l_ler_name ben_ler_f.NAME%TYPE;

600: l_threads NUMBER (15);
601: l_effective_date DATE;
602: l_from_ocrd_date DATE;
603: l_validate BOOLEAN := FALSE;
604: l_ler_name ben_ler_f.NAME%TYPE;
605: --
606: -- bug: 5578779
607: l_per_rec per_all_people_f%rowtype;
608: -- Cursors declaration

Line 646: FROM ben_ler_f

642: --
643: CURSOR c_ler
644: IS
645: SELECT NAME
646: FROM ben_ler_f
647: WHERE ler_id = p_ler_id;
648:
649: --
650: CURSOR c_per_in_ler (p_per_in_ler_id IN NUMBER)