DBA Data[Home] [Help]

APPS.PER_IN_DATA_PUMP dependencies on FND_TERRITORIES_TL

Line 237: FROM FND_TERRITORIES_TL ttl , FND_TERRITORIES t

233: RETURN VARCHAR2 IS
234: l_territory_code VARCHAR2(2);
235: BEGIN
236: SELECT ttl.territory_code into l_territory_code
237: FROM FND_TERRITORIES_TL ttl , FND_TERRITORIES t
238: WHERE ttl.TERRITORY_SHORT_NAME = p_issuing_country
239: AND ttl.TERRITORY_CODE = t.TERRITORY_CODE;
240:
241: RETURN l_territory_code;