381: l_api_updating boolean;
382: l_dummy varchar2(1);
383: --
384: cursor c1 is
385: select null from HR_ALL_ORGANIZATION_UNITS a
386: where a.business_group_id = p_business_group_id;
387:
388: --
389: Begin
400: <> nvl(pqh_cre_shd.g_old_rec.business_group_id,hr_api.g_number)
401: or not l_api_updating) then
402: --
403: -- check if business_group_id value exists in
404: -- HR_ALL_ORGANIZATION_UNITS table
405: --
406: open c1;
407: --
408:
411: if c1%notfound then
412: --
413: close c1;
414: --
415: -- raise error as FK does not relate to PK in HR_ALL_ORGANIZATION_UNITS
416: -- table.
417: --
418: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK3');
419: --