APPS.ARPT_SQL_FUNC_UTIL dependencies on FND_TERRITORIES_VL

Line 1439: l_territory fnd_territories_vl.territory_short_name%TYPE;

1435:
1436: FUNCTION get_territory( p_address_id IN NUMBER )
1437: RETURN VARCHAR2 IS
1438:
1439: l_territory fnd_territories_vl.territory_short_name%TYPE;
1440:
1441: /* modified for tca uptake */
1442: CURSOR c_territory IS
1443: select ft.territory_short_name

Line 1444: from fnd_territories_vl ft,

1440:
1441: /* modified for tca uptake */
1442: CURSOR c_territory IS
1443: select ft.territory_short_name
1444: from fnd_territories_vl ft,
1445: hz_cust_acct_sites acct_site,
1446: hz_party_sites party_site,
1447: hz_locations loc
1448: where loc.country = ft.territory_code

Line 1498: from fnd_territories_vl ft,

1494:
1495: /* modified for tca uptake */
1496: CURSOR c_territory IS
1497: select ft.rowid
1498: from fnd_territories_vl ft,
1499: hz_cust_acct_sites acct_site,
1500: hz_party_sites party_site,
1501: hz_locations loc
1502: where loc.country = ft.territory_code

Line 2067: FROM fnd_territories_vl

2063:
2064: BEGIN
2065: SELECT territory_short_name
2066: INTO l_territory_short_name
2067: FROM fnd_territories_vl
2068: WHERE territory_code = l_country;
2069: EXCEPTION
2070: WHEN no_data_found THEN
2071: l_territory_short_name := null;