APPS.BEN_BACK_OUT_CONC dependencies on PER_ALL_PEOPLE_F

Line 213: l_per_rec per_all_people_f%rowtype;

209: --
210: l_parm c_parameter%rowtype;
211: --
212: l_commit number;
213: l_per_rec per_all_people_f%rowtype;
214: l_per_dummy_rec per_all_people_f%rowtype;
215: --
216: cursor c_latest_ler is
217: select pil.per_in_ler_id,

Line 214: l_per_dummy_rec per_all_people_f%rowtype;

210: l_parm c_parameter%rowtype;
211: --
212: l_commit number;
213: l_per_rec per_all_people_f%rowtype;
214: l_per_dummy_rec per_all_people_f%rowtype;
215: --
216: cursor c_latest_ler is
217: select pil.per_in_ler_id,
218: ler.name

Line 287: from per_all_people_f ppf

283: --
284:
285: cursor c_person is
286: select ppf.*
287: from per_all_people_f ppf
288: where ppf.person_id = l_person_id
289: and nvl(l_effective_date,trunc(sysdate))
290: between ppf.effective_start_date
291: and ppf.effective_end_date;

Line 786: from per_all_people_f ppf

782: cursor c_person is
783: -- grade step backout
784: -- 3136058
785: select ppf.person_id
786: from per_all_people_f ppf
787: where -- bug 2547536 ppf.business_group_id = p_business_group_id and
788: l_effective_date
789: between ppf.effective_start_date
790: and ppf.effective_end_date

Line 845: from per_all_people_f pap

841: and paa.primary_flag = 'Y'
842: and paa.location_id = p_location_id))
843: and (p_benfts_grp_id is null
844: or exists (select null
845: from per_all_people_f pap
846: where pap.person_id = ppf.person_id
847: and pap.business_group_id = ppf.business_group_id
848: and l_effective_date
849: between pap.effective_start_date

Line 873: from per_all_people_f ppf

869: -- are fetched by the above sql, there is no need for the union
870: /*
871: UNION
872: select ppf.person_id
873: from per_all_people_f ppf
874: where l_effective_date between ppf.effective_start_date and ppf.effective_end_date
875: and exists (select null
876: from ben_per_in_ler pil,
877: ben_ler_f ler