APPS.PV_GE_CHKLST_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_checklist_item_name , FND_API.G_MISS_CHAR, NULL, p_checklist_item_name)
118: FROM fnd_languages l
119: WHERE l.installed_flag IN ('I','B')
120: AND NOT EXISTS(SELECT NULL FROM pv_ge_chklst_items_tl t
121: WHERE t.checklist_item_id = DECODE( px_checklist_item_id, FND_API.G_MISS_NUM, NULL, px_checklist_item_id)
122: AND t.language = l.language_code);

Line 298: FND_LANGUAGES L

294: b.checklist_item_name,
295: l.language_code,
296: b.source_lang
297: FROM pv_ge_chklst_items_tl B ,
298: FND_LANGUAGES L
299: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
300: AND B.LANGUAGE = USERENV ( 'LANG' )
301: ) v, pv_ge_chklst_items_tl t
302: WHERE t.checklist_item_id(+) = v.checklist_item_id