APPS.BEN_PRC_BUS dependencies on PER_ALL_PEOPLE_F

Line 511: -- The Provider Person Id can be either a person in PER_ALL_PEOPLE_F

507: --
508: -- Description
509: -- This procedure checks that a referenced foreign key actually exists
510: -- in the referenced table.
511: -- The Provider Person Id can be either a person in PER_ALL_PEOPLE_F
512: -- or an Org Unit ifrom HR_ALL_ORGANIZATION_UNITS. both places must
513: -- be checked.
514: --
515: -- Pre-Conditions

Line 550: from per_all_people_f

546: where a.organization_id = p_provider_person_id;
547: --
548: cursor c2 is
549: select null
550: from per_all_people_f
551: where person_id = p_provider_person_id;
552: --
553: Begin
554: --

Line 574: -- not exist in HR_ALL_ORGANIZATION_UNITS so will check PER_ALL_PEOPLE_F

570: open c1;
571: fetch c1 into l_dummy;
572: if c1%notfound then
573: --
574: -- not exist in HR_ALL_ORGANIZATION_UNITS so will check PER_ALL_PEOPLE_F
575: --
576: open c2;
577: fetch c2 into l_dummy;
578: if c2%notfound then

Line 584: -- table or PER_ALL_PEOPLE_F table.

580: close c1;
581: close c2;
582: --
583: -- raise error as FK does not relate to PK in hr_all_organization_units
584: -- table or PER_ALL_PEOPLE_F table.
585: --
586: ben_prc_shd.constraint_error('BEN_PRTT_REIMBMT_RQST_F_DT6');
587: --
588: end if;