DBA Data[Home] [Help]

APPS.PA_RESOURCE_CLASSES_PVT dependencies on FND_LANGUAGES

Line 70: from FND_LANGUAGES L

66: P_NAME,
67: P_DESCRIPTION,
68: L.LANGUAGE_CODE,
69: userenv('LANG')
70: from FND_LANGUAGES L
71: where L.INSTALLED_FLAG in ('I', 'B')
72: and not exists
73: (select NULL
74: from PA_RESOURCE_CLASSES_TL T

Line 234: from pa_resource_classes_tl B, FND_LANGUAGES L

230: B.NAME,
231: B.DESCRIPTION,
232: L.LANGUAGE_CODE,
233: B.SOURCE_LANG
234: from pa_resource_classes_tl B, FND_LANGUAGES L
235: where L.INSTALLED_FLAG in ('I', 'B')
236: and B.LANGUAGE = userenv('LANG')
237: and not exists
238: (select NULL

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

258: SOURCE_LANG = userenv('LANG') --For bug 4129599
259: where RESOURCE_CLASS_ID = P_RESOURCE_CLASS_ID
260: /*Bug4129599- Changes Start */
261: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
262: -- (select LANGUAGE_CODE from FND_LANGUAGES where INSTALLED_FLAG = 'B');
263: /*Bug4129599- Changes End */
264:
265: if (sql%notfound) then
266: raise no_data_found;