APPS.AMS_MTL_CATG_LOADER_PVT dependencies on FND_LANGUAGES

Line 44: from fnd_languages

40: c1_rec c1%ROWTYPE;
41:
42:
43: /*****cursor get_lang is select language_code
44: from fnd_languages
45: where installed_flag in ('I','B');
46: l_language VARCHAR2(20); ****/
47:
48:

Line 137: FROM fnd_languages l

133: sysdate,
134: FND_GLOBAL.user_id,
135: FND_GLOBAL.conc_login_id,
136: FND_FLEX_KEYVAL.concatenated_descriptions
137: FROM fnd_languages l
138: WHERE l.installed_flag IN ('I', 'B')
139: AND NOT EXISTS (SELECT NULL
140: FROM AMS_MTL_CATEGORIES_DENORM_TL t
141: WHERE t.category_id = c1_rec.category_id

Line 218: from AMS_MTL_CATEGORIES_DENORM_TL B, FND_LANGUAGES L

214: B.CREATION_DATE,
215: B.CREATED_BY,
216: B.LAST_UPDATE_LOGIN,
217: B.concatenated_description
218: from AMS_MTL_CATEGORIES_DENORM_TL B, FND_LANGUAGES L
219: where L.INSTALLED_FLAG in ('I', 'B')
220: and B.LANGUAGE = userenv('LANG')
221: and not exists
222: (select NULL