APPS.JTF_TASKS_PKG dependencies on FND_LANGUAGES

Line 436: FROM fnd_languages l

432: x_last_update_login,
433: x_task_id,
434: l.language_code,
435: USERENV ('LANG')
436: FROM fnd_languages l
437: WHERE l.installed_flag IN ('I', 'B')
438: AND NOT EXISTS (SELECT NULL
439: FROM jtf_tasks_tl t
440: WHERE t.task_id = x_task_id

Line 1022: FROM jtf_tasks_tl b, fnd_languages l

1018: b.last_update_login,
1019: b.task_id,
1020: l.language_code,
1021: b.source_lang
1022: FROM jtf_tasks_tl b, fnd_languages l
1023: WHERE l.installed_flag IN ('I', 'B')
1024: AND b.language = USERENV ('LANG')
1025: AND NOT EXISTS (SELECT NULL
1026: FROM jtf_tasks_tl t

Line 1042: FROM fnd_languages l, jtf_tasks_tl b

1038: FROM ( SELECT /*+ no_merge ordered parallel(b) */
1039: b.task_name, b.description, b.created_by, b.creation_date,
1040: b.last_updated_by, b.last_update_date, b.last_update_login,
1041: b.task_id, l.language_code, b.source_lang
1042: FROM fnd_languages l, jtf_tasks_tl b
1043: WHERE l.installed_flag IN ('I', 'B')
1044: AND b.language = USERENV ('LANG')
1045: ) v, jtf_tasks_tl t
1046: WHERE t.task_id(+) = v.task_id