195: SELECT
196: TERRITORY_SHORT_NAME
197: INTO RP_TERRITORY_CODE
198: FROM
199: FND_TERRITORIES_VL
200: WHERE TERRITORY_CODE = P_SHIP_TO_COUNTRY_CODE;
201: LP_COUNTRY_FROM := ' wsh_locations wl, ';
202: LP_COUNTRY_WHERE := ' and wdd.ship_to_location_id = wl.wsh_location_id
203: and wl.country = :p_ship_to_country_code ';