DBA Data[Home] [Help]

APPS.INV_MGD_MVT_UTILS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1279: HR_ALL_ORGANIZATION_UNITS hr

1275: IS
1276: SELECT
1277: hrl.country
1278: FROM
1279: HR_ALL_ORGANIZATION_UNITS hr
1280: , HR_LOCATIONS_ALL hrl
1281: WHERE hr.location_id = hrl.location_id
1282: AND hr.organization_id = p_warehouse_id;
1283:

Line 1811: FROM HR_ALL_ORGANIZATION_UNITS O

1807: , p_customer_id => l_sold_to_org_id
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