DBA Data[Home] [Help]

APPS.INV_MGD_MVT_UTILS_PKG dependencies on HR_LOCATIONS_ALL

Line 1280: , HR_LOCATIONS_ALL hrl

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:
1284: CURSOR l_fnd_cy

Line 1364: , HR_LOCATIONS_ALL hrl

1360: SELECT
1361: hrl.country
1362: FROM
1363: mtl_secondary_inventories msi
1364: , HR_LOCATIONS_ALL hrl
1365: WHERE hrl.location_id = msi.location_id
1366: AND msi.organization_id = p_warehouse_id
1367: AND msi.secondary_inventory_name = p_subinv_code;
1368:

Line 1996: l_country hr_locations_all.country%TYPE;

1992: ( p_le_id IN NUMBER
1993: )
1994: RETURN VARCHAR2
1995: IS
1996: l_country hr_locations_all.country%TYPE;
1997: l_short_name hr_locations_all.country%TYPE;
1998:
1999: CURSOR c_country IS
2000: SELECT

Line 1997: l_short_name hr_locations_all.country%TYPE;

1993: )
1994: RETURN VARCHAR2
1995: IS
1996: l_country hr_locations_all.country%TYPE;
1997: l_short_name hr_locations_all.country%TYPE;
1998:
1999: CURSOR c_country IS
2000: SELECT
2001: country