APPS.BEN_REOPEN_LER_CONC dependencies on PER_ALL_PEOPLE_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 128: FROM per_all_people_f pap

124: )
125: AND ( p_benfts_grp_id IS NULL
126: OR EXISTS (
127: SELECT NULL
128: FROM per_all_people_f pap
129: WHERE pap.person_id = per.person_id
130: AND pap.business_group_id = per.business_group_id
131: AND l_effective_date
132: BETWEEN pap.effective_start_date

Line 607: l_per_rec per_all_people_f%rowtype;

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
609: --
610: CURSOR c_range_thread
611: IS