APPS.HR_DELETE dependencies on HR_ORGANIZATION_UNITS

Line 1966: l_organization_id hr_organization_units.organization_id%TYPE;

1962: l_proc varchar2(80) := g_package||'delete_org_direct';
1963: --
1964: l_exists varchar2(1);
1965: --
1966: l_organization_id hr_organization_units.organization_id%TYPE;
1967: --
1968: l_security_group_id per_business_groups.security_group_id%TYPE;
1969: --
1970: cursor csr_get_ost

Line 1999: FROM hr_organization_units hou

1995: DELETE FROM hr_organization_information hoi
1996: WHERE
1997: EXISTS
1998: (SELECT ''
1999: FROM hr_organization_units hou
2000: WHERE hou.organization_id = hoi.organization_id
2001: AND hou.business_group_id = p_business_group_id);
2002: --
2003: hr_utility.set_location('Entering: '||l_proc, 14);

Line 2095: DELETE hr_organization_units

2091: close csr_get_ost;
2092: hr_utility.set_location(l_proc, 60);
2093: --
2094: if p_rt_running = 'N' then
2095: DELETE hr_organization_units
2096: WHERE business_group_id = p_business_group_id
2097: AND organization_id <> p_business_group_id;
2098: end if;
2099: hr_utility.set_location('Leaving: '||l_proc, 100);