APPS.OZF_NA_RULE_HEADER_PKG dependencies on FND_LANGUAGES

Line 112: FROM fnd_languages l

108: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
109: USERENV('LANG'),
110: DECODE( p_name, FND_API.G_MISS_CHAR, NULL, p_name),
111: DECODE( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
112: FROM fnd_languages l
113: WHERE l.installed_flag IN ('I','B')
114: AND NOT EXISTS(SELECT NULL FROM ozf_na_rule_headers_tl t
115: WHERE t.na_rule_header_id = DECODE( px_na_rule_header_id, FND_API.G_MISS_NUM, NULL, px_na_rule_header_id)
116: AND t.language = l.language_code);

Line 328: from ozf_na_rule_headers_tl b, fnd_languages l

324: b.name,
325: b.description,
326: l.language_code,
327: b.source_lang
328: from ozf_na_rule_headers_tl b, fnd_languages l
329: where l.installed_flag in ('I', 'B')
330: and b.language = userenv('lang')
331: and not exists
332: (select null