DBA Data[Home] [Help]

APPS.AST_UWQ_MLIST_MSG_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 32

     select  '< Campaign: ' || a.description  || ' >  < Schedule: ' || b.description || ' >'
	from    ams_campaigns_all_tl a,
        ams_campaign_schedules_vl b
	where   a.campaign_id = b.campaign_id
	and 	a.language = userenv('LANG')
	and     b.schedule_id  = p_schedule_id;