APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on FND_TERRITORIES_TL

Line 1708: l_country fnd_territories_tl.territory_short_name%TYPE;

1704: l_address_line_4 hz_locations.address4%TYPE;
1705: l_town_or_city hz_locations.city%TYPE;
1706: l_region hz_locations.county%TYPE;
1707: l_postal_code hz_locations.postal_code%TYPE;
1708: l_country fnd_territories_tl.territory_short_name%TYPE;
1709: BEGIN
1710: SELECT loc_bill.address1,
1711: loc_bill.address2,
1712: loc_bill.address3,

Line 1727: fnd_territories_tl terr_bill

1723: l_region,
1724: l_postal_code,
1725: l_country
1726: FROM hz_locations loc_bill,
1727: fnd_territories_tl terr_bill
1728: WHERE loc_bill.country = terr_bill.territory_code(+)
1729: AND decode(loc_bill.country,null,userenv('LANG'),terr_bill.language) = userenv('LANG')
1730: AND loc_bill.location_id =cf_bill_to_loc;
1731: cp_bill_address_line_1 := l_address_line_1;