APPS.AMS_CAMPAIGN_SCHEDULES_B_PKG dependencies on FND_LANGUAGES

Line 441: FROM fnd_languages l

437: -- removed by soagrawa on 24-sep-2001
438: -- DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id),
439: DECODE( p_greeting_text, FND_API.g_miss_char, NULL, p_greeting_text),
440: DECODE( p_footer_text, FND_API.g_miss_char, NULL, p_footer_text)
441: FROM fnd_languages l
442: WHERE l.installed_flag IN ('I','B')
443: AND NOT EXISTS(
444: SELECT NULL
445: FROM ams_campaign_schedules_tl t

Line 892: from ams_campaign_schedules_tl B, FND_LANGUAGES L

888: B.footer_text,
889: B.DESCRIPTION,
890: L.LANGUAGE_CODE,
891: B.SOURCE_LANG
892: from ams_campaign_schedules_tl B, FND_LANGUAGES L
893: where L.INSTALLED_FLAG in ('I', 'B')
894: and B.LANGUAGE = userenv('LANG')
895: and not exists
896: (select NULL