APPS.PER_DIS_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 799: from hr_all_organization_units hou

795: is
796: --
797: cursor csr_org is
798: select business_group_id
799: from hr_all_organization_units hou
800: where hou.organization_id = p_organization_id
801: and p_validation_start_date between hou.date_from and nvl(hou.date_to, hr_api.g_eot)
802: and hou.internal_external_flag = 'EXT';
803: --

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

841: (per_dis_shd.g_old_rec.organization_id <> p_organization_id))) then
842: --
843: hr_utility.set_location(l_proc, 30);
844: --
845: -- check org exists in hr_all_organization_units (fk) for the persons bg
846: -- within the validation date range.
847: open csr_org;
848: fetch csr_org into l_business_group_id;
849: if csr_org%notfound then