APPS.PER_MEA_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 332: from hr_all_organization_units hou

328: ,p_effective_date IN date) IS
329: --
330: cursor csr_org is
331: select business_group_id
332: from hr_all_organization_units hou
333: where hou.organization_id = p_organization_id
334: and p_effective_date between hou.date_from and nvl(hou.date_to, hr_api.g_eot);
335: --
336: cursor csr_org_inf is

Line 369: -- check org exists in hr_all_organization_units (fk) for the persons bg

365: per_mea_shd.g_old_rec.organization_id <> p_organization_id THEN
366: --
367: hr_utility.set_location(l_proc, 20);
368: --
369: -- check org exists in hr_all_organization_units (fk) for the persons bg
370: -- within the validation date range.
371: --
372: OPEN csr_org;
373: FETCH csr_org INTO l_business_group_id;