APPS.JTF_TASK_TYPES_PKG dependencies on FND_LANGUAGES

Line 142: FROM fnd_languages l

138: x_last_update_date,
139: x_last_update_login,
140: l.language_code,
141: USERENV ('LANG')
142: FROM fnd_languages l
143: WHERE l.installed_flag IN ('I', 'B')
144: AND NOT EXISTS (SELECT NULL
145: FROM jtf_task_types_tl t
146: WHERE t.task_type_id = x_task_type_id

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

353: last_update_login,
354: language,
355: source_lang
356: )
357: SELECT /*+ INDEX(b JTF_TASK_TYPES_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added Index Hint on 30/05/2006 for bug# 5213367
358: b.task_type_id,
359: b.name,
360: b.description,
361: b.created_by,

Line 368: FROM jtf_task_types_tl b, fnd_languages l

364: b.last_update_date,
365: b.last_update_login,
366: l.language_code,
367: b.source_lang
368: FROM jtf_task_types_tl b, fnd_languages l
369: WHERE l.installed_flag IN ('I', 'B')
370: AND b.language = USERENV ('LANG')
371: AND NOT EXISTS (SELECT NULL
372: FROM jtf_task_types_tl t