APPS.PV_GQ_ELEMENTS_PKG dependencies on FND_LANGUAGES

Line 124: FROM fnd_languages l

120: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
121: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
122: USERENV('LANG'),
123: DECODE( p_elmt_content, FND_API.G_MISS_CHAR, NULL, p_elmt_content)
124: FROM fnd_languages l
125: WHERE l.installed_flag IN ('I','B')
126: AND NOT EXISTS(SELECT NULL FROM pv_ge_qsnr_elements_tl t
127: WHERE t.qsnr_element_id = DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id)
128: AND t.language = l.language_code);

Line 312: FROM pv_ge_qsnr_elements_tl B , FND_LANGUAGES L

308: b.last_update_login,
309: b.elmt_content,
310: l.language_code,
311: b.source_lang
312: FROM pv_ge_qsnr_elements_tl B , FND_LANGUAGES L
313: WHERE L.INSTALLED_FLAG IN ( 'I','B' ) AND B.LANGUAGE = USERENV ( 'LANG' )
314: ) v
315: , pv_ge_qsnr_elements_tl t
316: WHERE t.qsnr_element_id(+) = v.qsnr_element_id

Line 409: from FND_LANGUAGES L

405: X_LAST_UPDATE_DATE,
406: X_LAST_UPDATE_LOGIN,
407: L.LANGUAGE_CODE,
408: userenv('LANG')
409: from FND_LANGUAGES L
410: where L.INSTALLED_FLAG in ('I', 'B')
411: and not exists
412: (select NULL
413: from PV_GE_QSNR_ELEMENTS_TL T