DBA Data[Home] [Help]

APPS.IMC_CSV_LOAD dependencies on FND_TERRITORIES

Line 233: select count(*) from FND_TERRITORIES where TERRITORY_CODE=country_cd AND OBSOLETE_FLAG = 'N';

229: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE)) ;
230:
231: -- Bug 4310158: Should only allow valid country code
232: cursor country_code(country_cd VARCHAR2) is
233: select count(*) from FND_TERRITORIES where TERRITORY_CODE=country_cd AND OBSOLETE_FLAG = 'N';
234:
235: cursor language_code(language_cd VARCHAR2) is
236: select count(*) from FND_LANGUAGES where LANGUAGE_CODE IN ('B', 'I') and LANGUAGE_CODE=language_cd;
237: