APPS.JTF_TASK_TEMP_GROUPS_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_TEMP_GROUPS_TL T

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

310: LAST_UPDATE_DATE,
311: LAST_UPDATE_LOGIN,
312: LANGUAGE,
313: SOURCE_LANG
314: ) select /*+ INDEX(b JTF_TASK_TEMP_GROUPS_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added Index Hint on 30/05/2006 for bug# 5213367
315: B.TASK_TEMPLATE_GROUP_ID,
316: B.TEMPLATE_GROUP_NAME,
317: B.DESCRIPTION,
318: B.CREATED_BY,

Line 325: from JTF_TASK_TEMP_GROUPS_TL B, FND_LANGUAGES L

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