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 2585: , HR_ORGANIZATION_INFORMATION O2

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

Line 2586: , HR_ORGANIZATION_INFORMATION O3

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