APPS.BEN_EGD_BUS dependencies on PER_ALL_PEOPLE_F

Line 275: from per_all_people_f a

271: l_dummy varchar2(1);
272: --
273: cursor c1 is
274: select null
275: from per_all_people_f a
276: where a.person_id = p_dpnt_person_id
277: and p_effective_date
278: between a.effective_start_date
279: and a.effective_end_date;

Line 294: -- check if person_id value exists in per_all_people_f table

290: and nvl(p_dpnt_person_id,hr_api.g_number)
291: <> nvl(ben_egd_shd.g_old_rec.dpnt_person_id,hr_api.g_number)
292: or not l_api_updating) then
293: --
294: -- check if person_id value exists in per_all_people_f table
295: --
296: open c1;
297: --
298: fetch c1 into l_dummy;

Line 303: -- raise error as FK does not relate to PK in per_all_people_f

299: if c1%notfound then
300: --
301: close c1;
302: --
303: -- raise error as FK does not relate to PK in per_all_people_f
304: -- table.
305: --
306: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_DT4');
307: --