APPS.XLE_UPGRADE_UTILS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 17: FROM hr_all_organization_units o,

13: IS
14:
15: cursor check_org_id(p_org_Id IN NUMBER) is
16: SELECT o.organization_id
17: FROM hr_all_organization_units o,
18: hr_organization_information o2,
19: hr_organization_information o3
20: WHERE o.organization_id = o2.organization_id
21: AND o.organization_id = o3.organization_id

Line 33: hr_all_organization_units o,

29:
30: cursor get_sob_id(p_org_id IN NUMBER) is
31: SELECT to_number(o3.org_information3)
32: FROM hr_organization_information o3,
33: hr_all_organization_units o,
34: hr_organization_information o2
35: WHERE o.organization_id = o2.organization_id
36: AND o.organization_id = o3.organization_id
37: AND o3.organization_id = o2.organization_id

Line 53: HR_ALL_ORGANIZATION_UNITS O,

49:
50: cursor check_le_mapped(p_org_id IN NUMBER) is
51: select O3.org_information2
52: from
53: HR_ALL_ORGANIZATION_UNITS O,
54: HR_ORGANIZATION_INFORMATION O2,
55: HR_ORGANIZATION_INFORMATION O3
56: where
57: O.organization_id=p_org_id