APPS.OZF_FUNDTHRESHOLDS_ALL_B_PKG dependencies on FND_LANGUAGES

Line 245: FROM fnd_languages l

241: , USERENV('LANG')
242: , p_source_lang
243: ,TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10)) -- ORG_ID
244: ,p_security_group_id
245: FROM fnd_languages l
246: WHERE l.installed_flag IN('I', 'B')
247: AND NOT EXISTS(SELECT NULL
248: FROM ozf_thresholds_all_tl t
249: WHERE t.threshold_id = px_threshold_id

Line 674: from OZF_THRESHOLDS_ALL_TL B, FND_LANGUAGES L

670: B.NAME,
671: B.DESCRIPTION,
672: L.LANGUAGE_CODE,
673: B.SOURCE_LANG
674: from OZF_THRESHOLDS_ALL_TL B, FND_LANGUAGES L
675: where L.INSTALLED_FLAG in ('I', 'B')
676: and B.LANGUAGE = userenv('LANG')
677: and not exists
678: (select NULL