APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on PER_ALL_PEOPLE_F

Line 173: , per_all_people_f per

169: , per.full_name
170: , info.business_group_id
171: FROM per_business_groups_perf bg
172: , ben_cwb_person_info info
173: , per_all_people_f per
174: , ben_per_in_ler pil
175: WHERE info.group_per_in_ler_id = v_group_per_in_ler_id
176: AND bg.business_group_id = info.business_group_id
177: AND v_effective_date >= bg.date_from

Line 4163: l_person_id per_all_people_f.person_id%type;

4159: l_lf_evt_orcd_date DATE;
4160: l_dummy c_slaves%ROWTYPE;
4161: l_person_ok varchar2(1) := 'Y';
4162: l_err_message varchar2(2000);
4163: l_person_id per_all_people_f.person_id%type;
4164: pl_rec c_placeholder_selection%ROWTYPE;
4165: l_count NUMBER;
4166: l_mgr_per_in_ler_ids g_number_type := g_number_type ();
4167: l_pils_for_access c_pils_for_access%ROWTYPE;