APPS.BEN_PRB_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 266: from hr_all_organization_units a

262: l_dummy varchar2(1);
263: --
264: cursor c1 is
265: select null
266: from hr_all_organization_units a
267: where a.organization_id = p_organization_id;
268: --
269: Begin
270: --

Line 284: -- check if organization_id value exists in hr_all_organization_units table

280: <> nvl(ben_prb_shd.g_old_rec.organization_id,hr_api.g_number)
281: or not l_api_updating) and
282: p_organization_id is not null then
283: --
284: -- check if organization_id value exists in hr_all_organization_units table
285: --
286: open c1;
287: --
288: fetch c1 into l_dummy;