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
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:
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
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