APPS.BEN_BACK_OUT_CONC dependencies on PER_ALL_PEOPLE_F

Line 218: l_per_rec per_all_people_f%rowtype;

214: --
215: l_parm c_parameter%rowtype;
216: --
217: l_commit number;
218: l_per_rec per_all_people_f%rowtype;
219: l_per_dummy_rec per_all_people_f%rowtype;
220: --
221: cursor c_latest_ler is
222: select pil.per_in_ler_id,

Line 219: l_per_dummy_rec per_all_people_f%rowtype;

215: l_parm c_parameter%rowtype;
216: --
217: l_commit number;
218: l_per_rec per_all_people_f%rowtype;
219: l_per_dummy_rec per_all_people_f%rowtype;
220: --
221: cursor c_latest_ler is
222: select pil.per_in_ler_id,
223: ler.name

Line 292: from per_all_people_f ppf

288: --
289:
290: cursor c_person is
291: select ppf.*
292: from per_all_people_f ppf
293: where ppf.person_id = l_person_id
294: and nvl(l_effective_date,trunc(sysdate))
295: between ppf.effective_start_date
296: and ppf.effective_end_date;

Line 812: from per_all_people_f ppf

808: cursor c_person is
809: -- grade step backout
810: -- 3136058
811: select ppf.person_id
812: from per_all_people_f ppf
813: where -- bug 2547536 ppf.business_group_id = p_business_group_id and
814: l_effective_date
815: between ppf.effective_start_date
816: and ppf.effective_end_date

Line 871: from per_all_people_f pap

867: and paa.primary_flag = 'Y'
868: and paa.location_id = p_location_id))
869: and (p_benfts_grp_id is null
870: or exists (select null
871: from per_all_people_f pap
872: where pap.person_id = ppf.person_id
873: and pap.business_group_id = ppf.business_group_id
874: and l_effective_date
875: between pap.effective_start_date

Line 899: from per_all_people_f ppf

895: -- are fetched by the above sql, there is no need for the union
896: /*
897: UNION
898: select ppf.person_id
899: from per_all_people_f ppf
900: where l_effective_date between ppf.effective_start_date and ppf.effective_end_date
901: and exists (select null
902: from ben_per_in_ler pil,
903: ben_ler_f ler