APPS.JTF_TASK_PRIORITIES_PKG dependencies on FND_LANGUAGES

Line 118: from FND_LANGUAGES L

114: X_LAST_UPDATE_DATE,
115: X_LAST_UPDATE_LOGIN,
116: L.LANGUAGE_CODE,
117: userenv('LANG')
118: from FND_LANGUAGES L
119: where L.INSTALLED_FLAG in ('I', 'B')
120: and not exists
121: (select NULL
122: from JTF_TASK_PRIORITIES_TL T

Line 313: ) select /*+ INDEX(b JTF_TASK_PRIORITIES_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added index hint for bug# 5213367 on 30/05/2006

309: LAST_UPDATE_DATE,
310: LAST_UPDATE_LOGIN,
311: LANGUAGE,
312: SOURCE_LANG
313: ) select /*+ INDEX(b JTF_TASK_PRIORITIES_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added index hint for bug# 5213367 on 30/05/2006
314: B.TASK_PRIORITY_ID,
315: B.NAME,
316: B.DESCRIPTION,
317: B.CREATED_BY,

Line 324: from JTF_TASK_PRIORITIES_TL B, FND_LANGUAGES L

320: B.LAST_UPDATE_DATE,
321: B.LAST_UPDATE_LOGIN,
322: L.LANGUAGE_CODE,
323: B.SOURCE_LANG
324: from JTF_TASK_PRIORITIES_TL B, FND_LANGUAGES L
325: where L.INSTALLED_FLAG in ('I', 'B')
326: and B.LANGUAGE = userenv('LANG')
327: and not exists
328: (select NULL