APPS.PON_OA_UTIL_PKG dependencies on FND_TERRITORIES_TL

Line 1342: v_territory_name fnd_territories_tl.territory_short_name%TYPE;

1338: v_zip_code hr_locations.postal_code%TYPE;
1339: v_postal_code hr_locations.postal_code%TYPE;
1340: v_country hr_locations.country%TYPE;
1341: v_county hr_locations.region_1%TYPE;
1342: v_territory_name fnd_territories_tl.territory_short_name%TYPE;
1343: v_return_string VARCHAR2(1000);
1344:
1345: BEGIN
1346:

Line 1378: FROM fnd_territories_tl tl

1374: BEGIN
1375: SELECT
1376: tl.territory_short_name
1377: INTO v_territory_name
1378: FROM fnd_territories_tl tl
1379: WHERE tl.territory_code = v_country
1380: AND tl.territory_code NOT IN ('ZR','FX','LX')
1381: AND tl.language = p_language;
1382: EXCEPTION