APPS.AP_VENDOR_PUB_PKG dependencies on FND_TERRITORIES

Line 2385: FROM fnd_territories_vl

2381: p_valid := TRUE;
2382:
2383: SELECT count(*)
2384: INTO l_count
2385: FROM fnd_territories_vl
2386: WHERE territory_code = p_country_of_origin_code;
2387:
2388: IF (l_count = 0) THEN
2389: FND_MESSAGE.SET_NAME('SQLAP','AP_API_INVALID_COUNTRY_OF_ORIG');

Line 11384: FROM FND_TERRITORIES

11380:
11381: IF(p_vendor_site_rec.country IS NOT NULL) THEN
11382: BEGIN
11383: SELECT null INTO l_dummy
11384: FROM FND_TERRITORIES
11385: WHERE TERRITORY_CODE = p_vendor_site_rec.country
11386: AND OBSOLETE_FLAG = 'N';
11387: x_valid := TRUE;
11388: