APPS.PQH_TCT_BUS dependencies on HR_ALL_ORGANIZATION_UNITS
Line 253: from hr_all_organization_units a
249: l_dummy varchar2(1);
250: --
251: cursor c1 is
252: select null 253: from hr_all_organization_units a 254: where a.organization_id = p_business_group_id;
255: --
256: Begin
257: --
Line 270: -- check if business_group_id exists in hr_all_organization_units table
266: <> nvl(pqh_tct_shd.g_old_rec.business_group_id,hr_api.g_number)
267: or not l_api_updating)
268: and p_business_group_id is not null then
269: -- 270: -- check if business_group_id exists in hr_all_organization_units table 271: --
272: open c1;
273: --
274: fetch c1 into l_dummy;