DBA Data[Home] [Help]

APPS.BEN_PDT_BUS dependencies on PER_ALL_PEOPLE_F

Line 508: from per_all_people_f a

504: l_dummy varchar2(1);
505: --
506: cursor c1 is
507: select null
508: from per_all_people_f a
509: where a.person_id = p_person_id;
510: --
511: Begin
512: --

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

520: and nvl(p_person_id,hr_api.g_number)
521: <> nvl(ben_pdt_shd.g_old_rec.person_id,hr_api.g_number)
522: or not l_api_updating) then
523: --
524: -- check if person_id value exists in per_all_people_f table
525: --
526: open c1;
527: --
528: fetch c1 into l_dummy;

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

529: if c1%notfound then
530: --
531: close c1;
532: --
533: -- raise error as FK does not relate to PK in per_all_people_f
534: -- table.
535: --
536: ben_pdt_shd.constraint_error('BEN_PYMT_CHECK_DET_FK2');
537: --