APPS.BEN_BEI_BUS dependencies on PER_ALL_PEOPLE_F

Line 356: from per_all_people_f a

352: l_dummy varchar2(1);
353: --
354: cursor c1 is
355: select null
356: from per_all_people_f a
357: where a.person_id = p_person_id
358: and p_effective_date
359: between a.effective_start_date
360: and a.effective_end_date;

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

371: and nvl(p_person_id,hr_api.g_number)
372: <> nvl(ben_bei_shd.g_old_rec.person_id,hr_api.g_number)
373: or not l_api_updating) then
374: --
375: -- check if person_id value exists in per_all_people_f table
376: --
377: open c1;
378: --
379: fetch c1 into l_dummy;

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

380: if c1%notfound then
381: --
382: close c1;
383: --
384: -- raise error as FK does not relate to PK in per_all_people_f
385: -- table.
386: --
387: ben_bei_shd.constraint_error('BEN_BATCH_ELIG_INFO_DT1');
388: --