APPS.BEN_PRC_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 512: -- or an Org Unit ifrom HR_ALL_ORGANIZATION_UNITS. both places must

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
516: -- None.

Line 545: from hr_all_organization_units a

541: l_dummy varchar2(1);
542: --
543: cursor c1 is
544: select null
545: from hr_all_organization_units a
546: where a.organization_id = p_provider_person_id;
547: --
548: cursor c2 is
549: select null

Line 568: -- check if provider_person_id value exists in hr_all_organization_units table

564: <> nvl(ben_prc_shd.g_old_rec.provider_person_id,hr_api.g_number)
565: or not l_api_updating) and
566: p_provider_person_id is not null then
567: --
568: -- check if provider_person_id value exists in hr_all_organization_units table
569: --
570: open c1;
571: fetch c1 into l_dummy;
572: if c1%notfound then

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 583: -- raise error as FK does not relate to PK in hr_all_organization_units

579: --
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: --