APPS.JTF_TASK_STATUSES_PKG dependencies on FND_LANGUAGES

Line 182: from FND_LANGUAGES L

178: X_LAST_UPDATE_DATE,
179: X_LAST_UPDATE_LOGIN,
180: L.LANGUAGE_CODE,
181: userenv('LANG')
182: from FND_LANGUAGES L
183: where L.INSTALLED_FLAG in ('I', 'B')
184: and not exists
185: (select NULL
186: from JTF_TASK_STATUSES_TL T

Line 421: ) select /*+ INDEX(b JTF_TASK_STATUSES_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added Index Hint on 30/05/2006 for bug# 5213367

417: LAST_UPDATE_DATE,
418: LAST_UPDATE_LOGIN,
419: LANGUAGE,
420: SOURCE_LANG
421: ) select /*+ INDEX(b JTF_TASK_STATUSES_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added Index Hint on 30/05/2006 for bug# 5213367
422: B.TASK_STATUS_ID,
423: B.NAME,
424: B.DESCRIPTION,
425: B.CREATED_BY,

Line 432: from JTF_TASK_STATUSES_TL B, FND_LANGUAGES L

428: B.LAST_UPDATE_DATE,
429: B.LAST_UPDATE_LOGIN,
430: L.LANGUAGE_CODE,
431: B.SOURCE_LANG
432: from JTF_TASK_STATUSES_TL B, FND_LANGUAGES L
433: where L.INSTALLED_FLAG in ('I', 'B')
434: and B.LANGUAGE = userenv('LANG')
435: and not exists
436: (select NULL