APPS.PV_GE_HIST_LOG_PKG dependencies on FND_LANGUAGES

Line 118: FROM fnd_languages l

114: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
115: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
116: USERENV('LANG'),
117: DECODE( p_COMMENTS , FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
118: FROM fnd_languages l
119: WHERE l.installed_flag IN ('I','B')
120: AND NOT EXISTS(SELECT NULL FROM pv_ge_history_log_tl t
121: WHERE t.entity_history_log_id = DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id)
122: AND t.language = l.language_code);

Line 304: FROM pv_ge_history_log_tl B , FND_LANGUAGES L

300: b.last_update_login,
301: b.comments,
302: l.language_code,
303: b.source_lang
304: FROM pv_ge_history_log_tl B , FND_LANGUAGES L
305: WHERE L.INSTALLED_FLAG IN ( 'I','B' ) AND B.LANGUAGE = USERENV ( 'LANG' )
306: ) v
307: , pv_ge_history_log_tl t
308: WHERE t.entity_history_log_id(+) = v.entity_history_log_id