DBA Data[Home] [Help]

APPS.PQH_RFE_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 638: select null from HR_ALL_ORGANIZATION_UNITS a

634: l_api_updating boolean;
635: l_dummy varchar2(1);
636: --
637: cursor c1 is
638: select null from HR_ALL_ORGANIZATION_UNITS a
639: where a.business_group_id = p_business_group_id;
640:
641: --
642: Begin

Line 657: -- HR_ALL_ORGANIZATION_UNITS table

653: <> nvl(pqh_rfe_shd.g_old_rec.business_group_id,hr_api.g_number)
654: or not l_api_updating) then
655: --
656: -- check if business_group_id value exists in
657: -- HR_ALL_ORGANIZATION_UNITS table
658: --
659: open c1;
660: --
661:

Line 668: -- raise error as FK does not relate to PK in HR_ALL_ORGANIZATION_UNITS

664: if c1%notfound then
665: --
666: close c1;
667: --
668: -- raise error as FK does not relate to PK in HR_ALL_ORGANIZATION_UNITS
669: -- table.
670: --
671: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK3');
672: --