DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on FND_TERRITORIES

Line 2098: FROM fnd_territories_vl

2094: p_valid := TRUE;
2095:
2096: SELECT count(*)
2097: INTO l_count
2098: FROM fnd_territories_vl
2099: WHERE territory_code = p_country_of_origin_code;
2100:
2101: IF (l_count = 0) THEN
2102: FND_MESSAGE.SET_NAME('SQLAP','AP_API_INVALID_COUNTRY_OF_ORIG');

Line 9634: FROM FND_TERRITORIES

9630:
9631: IF(p_vendor_site_rec.country IS NOT NULL) THEN
9632: BEGIN
9633: SELECT null INTO l_dummy
9634: FROM FND_TERRITORIES
9635: WHERE TERRITORY_CODE = p_vendor_site_rec.country
9636: AND OBSOLETE_FLAG = 'N';
9637: x_valid := TRUE;
9638: