APPS.BEN_EOU_BUS dependencies on HR_ORGANIZATION_UNITS

Line 190: from hr_organization_units a

186: l_exists varchar2(1);
187: --
188: cursor c1 is
189: select null
190: from hr_organization_units a
191: where a.organization_id = p_organization_id
192: and a.business_group_id + 0 = p_business_group_id
193: and p_effective_date between a.date_from and
194: nvl(a.date_to, p_effective_date)

Line 224: -- check if organization_id value exists in hr_organization_units table

220: and nvl(p_organization_id,hr_api.g_number)
221: <> nvl(ben_eou_shd.g_old_rec.organization_id,hr_api.g_number)
222: or not l_api_updating) then
223: --
224: -- check if organization_id value exists in hr_organization_units table
225: --
226: open c1;
227: --
228: fetch c1 into l_dummy;