eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLE_UPGRADE_UTILS dependencies on HR_ORGANIZATION_INFORMATION

Line 18: hr_organization_information o2,

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
22: AND o3.organization_id = o2.organization_id

Line 19: hr_organization_information o3

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
22: AND o3.organization_id = o2.organization_id
23: AND o2.org_information_context || '' = 'CLASS'

Line 32: FROM hr_organization_information o3,

28:
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

Line 34: hr_organization_information o2

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
38: AND o2.org_information_context || '' = 'CLASS'

Line 54: HR_ORGANIZATION_INFORMATION O2,

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
58: AND O.ORGANIZATION_ID = O2.ORGANIZATION_ID

Line 55: HR_ORGANIZATION_INFORMATION O3

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
58: AND O.ORGANIZATION_ID = O2.ORGANIZATION_ID
59: AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID