APPS.INV_MGD_MVT_UTILS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 1812: , HR_ORGANIZATION_INFORMATION O2

1808: , p_operating_unit_id => l_so_ou_id);*/
1809: SELECT To_Number(NVL(O3.ORG_INFORMATION2,-1))
1810: INTO l_so_le_id
1811: FROM HR_ALL_ORGANIZATION_UNITS O
1812: , HR_ORGANIZATION_INFORMATION O2
1813: , HR_ORGANIZATION_INFORMATION O3
1814: WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID
1815: AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
1816: AND O2.ORG_INFORMATION_CONTEXT||'' = 'CLASS'

Line 1813: , HR_ORGANIZATION_INFORMATION O3

1809: SELECT To_Number(NVL(O3.ORG_INFORMATION2,-1))
1810: INTO l_so_le_id
1811: FROM HR_ALL_ORGANIZATION_UNITS O
1812: , HR_ORGANIZATION_INFORMATION O2
1813: , HR_ORGANIZATION_INFORMATION O3
1814: WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID
1815: AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
1816: AND O2.ORG_INFORMATION_CONTEXT||'' = 'CLASS'
1817: AND O3.ORG_INFORMATION_CONTEXT = 'Operating Unit Information'

Line 1879: hr_organization_information

1875: CURSOR l_shipping_le IS
1876: SELECT
1877: TO_NUMBER(org_information2)
1878: FROM
1879: hr_organization_information
1880: WHERE org_information_context = 'Accounting Information'
1881: AND organization_id = p_warehouse_id;
1882:
1883: BEGIN

Line 2228: FROM hr_organization_information

2224: CURSOR c_org_id
2225: IS
2226: SELECT
2227: organization_id
2228: FROM hr_organization_information
2229: WHERE org_information_context = 'Accounting Information'
2230: --AND to_number(org_information2) = p_le_id
2231: AND org_information2 = to_char(p_le_id)
2232: AND rownum = 1;