APPS.BEN_PURGE_BCKDT_VOIDED dependencies on PER_ALL_PEOPLE_F

Line 304: select ppf.person_id from per_all_people_f ppf

300: l_from_ocrd_date date;
301: l_to_ocrd_date date;
302: --
303: cursor c_person is
304: select ppf.person_id from per_all_people_f ppf
305: where (ppf.person_id = p_person_id or p_person_id is null)
306: and ppf.business_group_id = p_business_group_id
307: and l_effective_date between ppf.effective_start_date
308: and ppf.effective_end_date

Line 331: from per_all_people_f pap

327: and paa.primary_flag = 'Y'
328: and paa.location_id = p_location_id))
329: and (p_benfts_grp_id is null
330: or exists (select null
331: from per_all_people_f pap
332: where pap.person_id = ppf.person_id
333: and pap.business_group_id = ppf.business_group_id
334: and l_effective_date
335: between pap.effective_start_date

Line 857: l_per_rec per_all_people_f%rowtype;

853: --
854: -- start bug 3079317
855: l_rec benutils.g_active_life_event;
856: l_env ben_env_object.g_global_env_rec_type;
857: l_per_rec per_all_people_f%rowtype;
858: l_encoded_message varchar2(2000);
859: l_app_short_name varchar2(2000);
860: l_message_name varchar2(2000);
861: g_rec ben_type.g_report_rec;