APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on FND_TERRITORIES_TL

Line 1471: l_country fnd_territories_tl.territory_short_name%TYPE;

1467: l_address_line_4 hz_locations.address4%TYPE;
1468: l_town_or_city hz_locations.city%TYPE;
1469: l_region hz_locations.county%TYPE;
1470: l_postal_code hz_locations.postal_code%TYPE;
1471: l_country fnd_territories_tl.territory_short_name%TYPE;
1472: BEGIN
1473: SELECT loc_bill.address1,
1474: loc_bill.address2,
1475: loc_bill.address3,

Line 1490: fnd_territories_tl terr_bill

1486: l_region,
1487: l_postal_code,
1488: l_country
1489: FROM hz_locations loc_bill,
1490: fnd_territories_tl terr_bill
1491: WHERE loc_bill.country = terr_bill.territory_code(+)
1492: AND decode(loc_bill.country,null,userenv('LANG'),terr_bill.language) = userenv('LANG')
1493: AND loc_bill.location_id =cf_bill_to_loc;
1494: cp_bill_address_line_1 := l_address_line_1;