824: FND_GLOBAL.Conc_Login_Id,
825: USERENV('LANG'),
826: l_venue_rec.venue_name,
827: l_venue_rec.description 828: FROM fnd_languages l 829: WHERE l.installed_flag IN ('I', 'B')
830: AND NOT EXISTS (SELECT NULL
831: FROM ams_venues_tl t
832: WHERE t.venue_id = l_venue_rec.venue_id