DBA Data[Home] [Help]

APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on AMS_CAMPAIGN_SCHEDULES

Line 245: AMS_CAMPAIGN_SCHEDULES_VL c,

241: INTO p_sublist_id,p_source_list_id,p_campaign_id,p_campaign_schedule_id,p_dialing_method
242: from
243: iec_g_list_subsets a,
244: ams_act_lists b,
245: AMS_CAMPAIGN_SCHEDULES_VL c,
246: ams_list_headers_all d
247: where
248: a.list_header_id = b.list_header_id AND
249: b.list_used_by_id = c.schedule_id AND

Line 481: from AMS_CAMPAIGN_SCHEDULES

477: p_campaign_schedule_id := NULL;
478:
479: elsif v_sc_code = 'CSCH' then
480: select campaign_schedule_id into p_campaign_schedule_id
481: from AMS_CAMPAIGN_SCHEDULES
482: where
483: source_code = p_source_code;
484:
485: p_campaign_id := NULL;