APPS.ARPT_SQL_FUNC_UTIL dependencies on FND_TERRITORIES_VL

Line 1529: l_territory fnd_territories_vl.territory_short_name%TYPE;

1525:
1526: FUNCTION get_territory( p_address_id IN NUMBER )
1527: RETURN VARCHAR2 IS
1528:
1529: l_territory fnd_territories_vl.territory_short_name%TYPE;
1530:
1531: /* modified for tca uptake */
1532: CURSOR c_territory IS
1533: select ft.territory_short_name

Line 1534: from fnd_territories_vl ft,

1530:
1531: /* modified for tca uptake */
1532: CURSOR c_territory IS
1533: select ft.territory_short_name
1534: from fnd_territories_vl ft,
1535: hz_cust_acct_sites acct_site,
1536: hz_party_sites party_site,
1537: hz_locations loc
1538: where loc.country = ft.territory_code

Line 1588: from fnd_territories_vl ft,

1584:
1585: /* modified for tca uptake */
1586: CURSOR c_territory IS
1587: select ft.rowid
1588: from fnd_territories_vl ft,
1589: hz_cust_acct_sites acct_site,
1590: hz_party_sites party_site,
1591: hz_locations loc
1592: where loc.country = ft.territory_code

Line 2186: FROM fnd_territories_vl

2182:
2183: BEGIN
2184: SELECT territory_short_name
2185: INTO l_territory_short_name
2186: FROM fnd_territories_vl
2187: WHERE territory_code = l_country;
2188: EXCEPTION
2189: WHEN no_data_found THEN
2190: l_territory_short_name := null;