APPS.PV_GE_NOTIF_RULES_PKG dependencies on FND_LANGUAGES

Line 148: FROM fnd_languages l

144: USERENV('LANG'),
145: DECODE( p_notif_name , FND_API.G_MISS_CHAR, NULL, p_notif_name),
146: DECODE( p_notif_content , FND_API.G_MISS_CHAR, NULL, p_notif_content),
147: DECODE( p_notif_desc , FND_API.G_MISS_CHAR, NULL, p_notif_desc)
148: FROM fnd_languages l
149: WHERE l.installed_flag IN ('I','B')
150: AND NOT EXISTS(SELECT NULL FROM pv_ge_notif_rules_tl t
151: WHERE t.notif_rule_id = DECODE( px_notif_rule_id, FND_API.G_MISS_NUM, NULL, px_notif_rule_id)
152: AND t.language = l.language_code);

Line 393: from pv_ge_notif_rules_tl b, fnd_languages l

389: --b.notif_rule_name,
390: --b.description,
391: l.language_code,
392: b.source_lang
393: from pv_ge_notif_rules_tl b, fnd_languages l
394: where l.installed_flag in ('I', 'B')
395: and b.language = userenv('lang')
396: and not exists
397: (select null