APPS.JTF_TASK_STATUSES_PKG dependencies on FND_LANGUAGES

Line 164: from FND_LANGUAGES L

160: X_LAST_UPDATE_DATE,
161: X_LAST_UPDATE_LOGIN,
162: L.LANGUAGE_CODE,
163: userenv('LANG')
164: from FND_LANGUAGES L
165: where L.INSTALLED_FLAG in ('I', 'B')
166: and not exists
167: (select NULL
168: from JTF_TASK_STATUSES_TL T

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

387: LAST_UPDATE_DATE,
388: LAST_UPDATE_LOGIN,
389: LANGUAGE,
390: SOURCE_LANG
391: ) select /*+ INDEX(b JTF_TASK_STATUSES_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added Index Hint on 30/05/2006 for bug# 5213367
392: B.TASK_STATUS_ID,
393: B.NAME,
394: B.DESCRIPTION,
395: B.CREATED_BY,

Line 402: from JTF_TASK_STATUSES_TL B, FND_LANGUAGES L

398: B.LAST_UPDATE_DATE,
399: B.LAST_UPDATE_LOGIN,
400: L.LANGUAGE_CODE,
401: B.SOURCE_LANG
402: from JTF_TASK_STATUSES_TL B, FND_LANGUAGES L
403: where L.INSTALLED_FLAG in ('I', 'B')
404: and B.LANGUAGE = userenv('LANG')
405: and not exists
406: (select NULL