APPS.CS_SR_SAVED_SEARCHES_PKG dependencies on FND_LANGUAGES

Line 58: from FND_LANGUAGES L where L.INSTALLED_FLAG in ('I', 'B')

54: X_LAST_UPDATE_DATE,
55: X_LAST_UPDATED_BY,
56: L.LANGUAGE_CODE,
57: userenv('LANG')
58: from FND_LANGUAGES L where L.INSTALLED_FLAG in ('I', 'B')
59: and not exists ( select NULL from CS_SR_SAVED_SEARCHES_TL T
60: where T.SEARCH_ID = X_SEARCH_ID
61: and T.LANGUAGE = L.LANGUAGE_CODE);
62:

Line 137: from CS_SR_SAVED_SEARCHES_TL B, FND_LANGUAGES L

133: B.LAST_UPDATE_DATE,
134: B.LAST_UPDATED_BY,
135: L.LANGUAGE_CODE,
136: B.SOURCE_LANG
137: from CS_SR_SAVED_SEARCHES_TL B, FND_LANGUAGES L
138: where L.INSTALLED_FLAG in ('I', 'B') and B.LANGUAGE = userenv('LANG')
139: and not exists (select NULL from CS_SR_SAVED_SEARCHES_TL T
140: where T.SEARCH_ID = B.SEARCH_ID
141: and T.LANGUAGE =L.LANGUAGE_CODE);