APPS.HR_SECURITY_INTERNAL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 4229: FROM hr_all_organization_units o

4225: CURSOR csr_get_bg_for_org
4226: (p_organization_id IN NUMBER)
4227: IS
4228: SELECT o.business_group_id
4229: FROM hr_all_organization_units o
4230: WHERE o.organization_id = p_organization_id;
4231:
4232: BEGIN
4233:

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

4281: --
4282: -- Unfortunately, there is no quick way of finding out the
4283: -- BGs for the orgs in the cache without fetching the BG for
4284: -- each org. The BG could be retrieved in the hierarchy tree-
4285: -- walk by joining to hr_all_organization_units but this would
4286: -- be an unnecessary hit where global profiles are not used.
4287: -- Instead, the BG for each org is retrieved separately here.
4288: --
4289: IF g_dbg THEN op(l_proc, 50); END IF;

Line 8384: FROM hr_all_organization_units ou

8380: -- Bug fix 4889068.
8381: -- SQL Tuned to improve performance.
8382: DELETE FROM per_organization_list ol
8383: WHERE EXISTS ( SELECT null
8384: FROM hr_all_organization_units ou
8385: WHERE ou.business_group_id = p_business_group_id
8386: and ou.organization_id = ol.organization_id);
8387: --
8388: hr_utility.set_location('hr_delete.delete_security_list_for_bg',7);

Line 8399: FROM hr_all_organization_units ou

8395: -- Bug fix 4889068.
8396: -- SQL Tuned to improve performance.
8397: DELETE FROM per_security_organizations pso
8398: WHERE EXISTS( SELECT null
8399: FROM hr_all_organization_units ou
8400: WHERE ou.business_group_id = p_business_group_id
8401: and ou.organization_id = pso.organization_id);
8402: --
8403: hr_utility.set_location('hr_delete.delete_security_list_for_bg',9);