APPS.XLE_UTILITIES_GRP dependencies on HR_ORGANIZATION_INFORMATION

Line 928: FROM HR_ALL_ORGANIZATION_UNITS O, HR_ORGANIZATION_INFORMATION O2, HR_ORGANIZATION_INFORMATION O3

924: l_commit VARCHAR2(100);
925: BEGIN
926: SELECT O3.ORG_INFORMATION3
927: INTO l_ledger_id
928: FROM HR_ALL_ORGANIZATION_UNITS O, HR_ORGANIZATION_INFORMATION O2, HR_ORGANIZATION_INFORMATION O3
929: WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID
930: AND O2.ORGANIZATION_ID = O3.ORGANIZATION_ID
931: AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
932: AND O2.ORG_INFORMATION_CONTEXT||'' = 'CLASS'

Line 1605: FROM HR_ALL_ORGANIZATION_UNITS O, HR_ORGANIZATION_INFORMATION O2, HR_ORGANIZATION_INFORMATION O3

1601:
1602: BEGIN
1603: SELECT O3.ORG_INFORMATION3
1604: INTO l_ledger_id
1605: FROM HR_ALL_ORGANIZATION_UNITS O, HR_ORGANIZATION_INFORMATION O2, HR_ORGANIZATION_INFORMATION O3
1606: WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID
1607: AND O2.ORGANIZATION_ID = O3.ORGANIZATION_ID
1608: AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
1609: AND O2.ORG_INFORMATION_CONTEXT||'' = 'CLASS'

Line 2583: , HR_ORGANIZATION_INFORMATION O2

2579:
2580: SELECT NVL(O3.ORG_INFORMATION2,-1)
2581: INTO DLC_VAL
2582: FROM HR_ALL_ORGANIZATION_UNITS O
2583: , HR_ORGANIZATION_INFORMATION O2
2584: , HR_ORGANIZATION_INFORMATION O3
2585: WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID
2586: AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
2587: AND O2.ORG_INFORMATION_CONTEXT||'' = 'CLASS'

Line 2584: , HR_ORGANIZATION_INFORMATION O3

2580: SELECT NVL(O3.ORG_INFORMATION2,-1)
2581: INTO DLC_VAL
2582: FROM HR_ALL_ORGANIZATION_UNITS O
2583: , HR_ORGANIZATION_INFORMATION O2
2584: , HR_ORGANIZATION_INFORMATION O3
2585: WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID
2586: AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
2587: AND O2.ORG_INFORMATION_CONTEXT||'' = 'CLASS'
2588: AND O3.ORG_INFORMATION_CONTEXT = 'Operating Unit Information'