APPS.PA_RES_FORMATS_PVT dependencies on FND_LANGUAGES

Line 112: from FND_LANGUAGES L

108: P_NAME,
109: P_DESCRIPTION,
110: L.LANGUAGE_CODE,
111: userenv('LANG')
112: from FND_LANGUAGES L
113: where L.INSTALLED_FLAG in ('I', 'B')
114: and not exists
115: (select NULL
116: from pa_res_formats_tl T

Line 319: from pa_res_formats_tl B, FND_LANGUAGES L

315: B.NAME,
316: B.DESCRIPTION,
317: L.LANGUAGE_CODE,
318: B.SOURCE_LANG
319: from pa_res_formats_tl B, FND_LANGUAGES L
320: where L.INSTALLED_FLAG in ('I', 'B')
321: and B.LANGUAGE = userenv('LANG')
322: and not exists
323: (select NULL

Line 347: -- (select LANGUAGE_CODE from FND_LANGUAGES where INSTALLED_FLAG = 'B');

343: SOURCE_LANG = userenv('LANG') --For bug 4129599
344: where res_format_id = P_RES_FORMAT_ID
345: /*Bug4129599- Changes Start */
346: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
347: -- (select LANGUAGE_CODE from FND_LANGUAGES where INSTALLED_FLAG = 'B');
348: /*Bug4129599- Changes End */
349:
350: if (sql%notfound) then
351: raise no_data_found;