APPS.BEN_IREC_BACK_OUT_CONC dependencies on PER_ALL_PEOPLE_F

Line 72: l_per_rec per_all_people_f%rowtype;

68: l_threads number(15);
69: l_effective_date date;
70: l_ocrd_date date;
71: l_commit number;
72: l_per_rec per_all_people_f%rowtype;
73: l_dummy2 number;
74: -- l_per_dummy_rec per_all_people_f%rowtype;
75:
76: -- Cursors declaration

Line 74: -- l_per_dummy_rec per_all_people_f%rowtype;

70: l_ocrd_date date;
71: l_commit number;
72: l_per_rec per_all_people_f%rowtype;
73: l_dummy2 number;
74: -- l_per_dummy_rec per_all_people_f%rowtype;
75:
76: -- Cursors declaration
77: --
78: Cursor c_range_thread is

Line 134: from per_all_people_f ppf

130: --
131: --
132: cursor c_person is
133: select ppf.*
134: from per_all_people_f ppf
135: where ppf.person_id = l_person_id
136: and nvl(l_effective_date,trunc(sysdate))
137: between ppf.effective_start_date
138: and ppf.effective_end_date;

Line 501: from per_all_people_f ppf

497: /* cursor definitions*/
498:
499: cursor c_person is
500: select distinct ppf.person_id, ppf.business_group_id
501: from per_all_people_f ppf
502: where l_effective_date between ppf.effective_start_date and ppf.effective_end_date
503: and exists (select null
504: from ben_per_in_ler pil
505: , ben_ler_f ler