DBA Data[Home] [Help]

APPS.BIX_CALL_UPDATE_PKG dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 411: from AMS_CAMPAIGN_SCHEDULES_B

407: elsif l_source_code_for = 'CSCH'
408: then
409: select schedule_id, campaign_id
410: into p_schedule_id, p_campaign_id
411: from AMS_CAMPAIGN_SCHEDULES_B
412: where source_code = p_source_code;
413:
414: else
415: p_campaign_id := NULL;

Line 431: AMS_CAMPAIGN_SCHEDULES_B c,

427: select c.campaign_id,c.schedule_id, code.source_code_id, d.dialing_method
428: INTO p_campaign_id,p_schedule_id,p_source_code_id,p_dialing_method
429: from iec_g_list_subsets a,
430: ams_act_lists b,
431: AMS_CAMPAIGN_SCHEDULES_B c,
432: ams_list_headers_all d,
433: ams_source_codes code
434: where
435: a.list_header_id = b.list_header_id AND