DBA Data[Home] [Help]

APPS.FND_OBIEE_I18N dependencies on FND_TERRITORIES

Line 314: -- FND_TERRITORIES table, the OBSOLETE_FLAG has to be 'N'

310:
311:
312: -- Convert EBS session language and session territory to OBIEE session locale;
313: -- Since there could be more than one record for the same territory in
314: -- FND_TERRITORIES table, the OBSOLETE_FLAG has to be 'N'
315: function obiee_session_locale return varchar2 is
316: o_locale varchar2(10) := null;
317: begin
318: select lower(fl.ISO_LANGUAGE)||'-'||lower(ft.TERRITORY_CODE)

Line 320: from fnd_languages fl, FND_TERRITORIES ft

316: o_locale varchar2(10) := null;
317: begin
318: select lower(fl.ISO_LANGUAGE)||'-'||lower(ft.TERRITORY_CODE)
319: into o_locale
320: from fnd_languages fl, FND_TERRITORIES ft
321: where fnd_global.nls_language = fl.nls_language
322: and fnd_global.nls_territory = ft.nls_territory
323: and ft.OBSOLETE_FLAG = 'N';
324: