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;