APPS.XLE_UTILITIES_GRP dependencies on HR_ALL_ORGANIZATION_UNITS

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 1566: l_party_id HR_ALL_ORGANIZATION_UNITS.PARTY_ID%TYPE;

1562: l_ledger_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;
1563: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE;
1564: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;
1565: l_index NUMBER;
1566: l_party_id HR_ALL_ORGANIZATION_UNITS.PARTY_ID%TYPE;
1567: l_ledger_flag BOOLEAN;
1568:
1569: l_init_msg_list VARCHAR2(100);
1570: l_commit VARCHAR2(100);

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 2582: FROM HR_ALL_ORGANIZATION_UNITS O

2578: -- SAVEPOINT Get_DefaultLegalContext_OU;
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