APPS.HR_SECURITY_INTERNAL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 4338: FROM hr_all_organization_units o

4334: CURSOR csr_get_bg_for_org
4335: (p_organization_id IN NUMBER)
4336: IS
4337: SELECT o.business_group_id
4338: FROM hr_all_organization_units o
4339: WHERE o.organization_id = p_organization_id;
4340:
4341: BEGIN
4342:

Line 4394: -- walk by joining to hr_all_organization_units but this would

4390: --
4391: -- Unfortunately, there is no quick way of finding out the
4392: -- BGs for the orgs in the cache without fetching the BG for
4393: -- each org. The BG could be retrieved in the hierarchy tree-
4394: -- walk by joining to hr_all_organization_units but this would
4395: -- be an unnecessary hit where global profiles are not used.
4396: -- Instead, the BG for each org is retrieved separately here.
4397: --
4398: IF g_dbg THEN op(l_proc, 50); END IF;

Line 9248: FROM hr_all_organization_units ou

9244: -- Bug fix 4889068.
9245: -- SQL Tuned to improve performance.
9246: DELETE FROM per_organization_list ol
9247: WHERE EXISTS ( SELECT null
9248: FROM hr_all_organization_units ou
9249: WHERE ou.business_group_id = p_business_group_id
9250: and ou.organization_id = ol.organization_id);
9251: --
9252: hr_utility.set_location('hr_delete.delete_security_list_for_bg',7);

Line 9263: FROM hr_all_organization_units ou

9259: -- Bug fix 4889068.
9260: -- SQL Tuned to improve performance.
9261: DELETE FROM per_security_organizations pso
9262: WHERE EXISTS( SELECT null
9263: FROM hr_all_organization_units ou
9264: WHERE ou.business_group_id = p_business_group_id
9265: and ou.organization_id = pso.organization_id);
9266: --
9267: hr_utility.set_location('hr_delete.delete_security_list_for_bg',9);