APPS.JTF_TASK_TYPES_PKG dependencies on FND_LANGUAGES

Line 148: FROM fnd_languages l

144: x_last_update_date,
145: x_last_update_login,
146: l.language_code,
147: USERENV ('LANG')
148: FROM fnd_languages l
149: WHERE l.installed_flag IN ('I', 'B')
150: AND NOT EXISTS (SELECT NULL
151: FROM jtf_task_types_tl t
152: WHERE t.task_type_id = x_task_type_id

Line 367: SELECT /*+ INDEX(b JTF_TASK_TYPES_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added Index Hint on 30/05/2006 for bug# 5213367

363: last_update_login,
364: language,
365: source_lang
366: )
367: SELECT /*+ INDEX(b JTF_TASK_TYPES_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added Index Hint on 30/05/2006 for bug# 5213367
368: b.task_type_id,
369: b.name,
370: b.description,
371: b.created_by,

Line 378: FROM jtf_task_types_tl b, fnd_languages l

374: b.last_update_date,
375: b.last_update_login,
376: l.language_code,
377: b.source_lang
378: FROM jtf_task_types_tl b, fnd_languages l
379: WHERE l.installed_flag IN ('I', 'B')
380: AND b.language = USERENV ('LANG')
381: AND NOT EXISTS (SELECT NULL
382: FROM jtf_task_types_tl t