1664: --
1665: --
1666: cursor c1 is
1667: select null
1668: from hr_all_organization_units a
1669: where a.organization_id = p_organization_id
1670: and a.business_group_id + 0 = p_business_group_id
1671: ;
1672: --
1684: and nvl(p_organization_id,hr_api.g_number)
1685: <> nvl(ben_pbn_shd.g_old_rec.organization_id, hr_api.g_number)
1686: or not l_api_updating) then
1687: --
1688: -- check if organization_id value exists in hr_all_organization_units table
1689: --
1690: open c1;
1691: --
1692: fetch c1 into l_dummy;