Line 236: select count(*) from FND_LANGUAGES where LANGUAGE_CODE IN ('B', 'I') and LANGUAGE_CODE=language_cd;
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:
238: cursor clss_category(p_class_category VARCHAR2) is
239: select count(*) from hz_class_categories where class_category = p_class_category;
240: