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 2011: l_country hr_locations_all.country%TYPE;

2007: ( p_le_id IN NUMBER
2008: )
2009: RETURN VARCHAR2
2010: IS
2011: l_country hr_locations_all.country%TYPE;
2012: l_short_name hr_locations_all.country%TYPE;
2013:
2014: CURSOR c_country IS
2015: SELECT

Line 2012: l_short_name hr_locations_all.country%TYPE;

2008: )
2009: RETURN VARCHAR2
2010: IS
2011: l_country hr_locations_all.country%TYPE;
2012: l_short_name hr_locations_all.country%TYPE;
2013:
2014: CURSOR c_country IS
2015: SELECT
2016: country