APPS.FND_FLEX_VALUES_PKG dependencies on FND_LANGUAGES

Line 246: from FND_LANGUAGES L

242: X_DESCRIPTION,
243: X_FLEX_VALUE_MEANING,
244: L.LANGUAGE_CODE,
245: userenv('LANG')
246: from FND_LANGUAGES L
247: where L.INSTALLED_FLAG in ('I', 'B')
248: and not exists
249: (select NULL
250: from FND_FLEX_VALUES_TL T

Line 740: from FND_LANGUAGES L

736: X_DESCRIPTION,
737: X_FLEX_VALUE_MEANING,
738: L.LANGUAGE_CODE,
739: userenv('LANG')
740: from FND_LANGUAGES L
741: where L.INSTALLED_FLAG in ('I', 'B')
742: and not exists
743: (select NULL
744: from FND_FLEX_VALUES_TL T

Line 798: from fnd_languages

794: CREATED_BY,
795: LAST_UPDATE_LOGIN,
796: FLEX_VALUE,
797: (select language_code
798: from fnd_languages
799: where installed_flag='B'),
800: (select language_code
801: from fnd_languages
802: where installed_flag='B')

Line 801: from fnd_languages

797: (select language_code
798: from fnd_languages
799: where installed_flag='B'),
800: (select language_code
801: from fnd_languages
802: where installed_flag='B')
803: FROM FND_FLEX_VALUES
804: WHERE FLEX_VALUE_ID NOT IN
805: (SELECT FLEX_VALUE_ID

Line 885: from FND_LANGUAGES L, FND_FLEX_VALUES_TL B

881: B.DESCRIPTION,
882: B.FLEX_VALUE_MEANING,
883: L.LANGUAGE_CODE,
884: B.SOURCE_LANG
885: from FND_LANGUAGES L, FND_FLEX_VALUES_TL B
886: where DECODE(L.INSTALLED_FLAG, 'I', 1, 'B', 1, 0) = 1
887: and B.LANGUAGE = userenv('LANG')
888: ) v, FND_FLEX_VALUES_TL t
889: where t.flex_value_id(+) = v.flex_value_id