DBA Data[Home] [Help]

APPS.BIX_CALL_LOAD_PKG dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 420: from AMS_CAMPAIGN_SCHEDULES_B

416: elsif l_source_code_for = 'CSCH'
417: then
418: select schedule_id, campaign_id
419: into p_schedule_id, p_campaign_id
420: from AMS_CAMPAIGN_SCHEDULES_B
421: where source_code = p_source_code;
422:
423: else
424: p_campaign_id := NULL;

Line 439: AMS_CAMPAIGN_SCHEDULES_B c,

435: select c.campaign_id,c.schedule_id, code.source_code_id, d.dialing_method
436: INTO p_campaign_id,p_schedule_id,p_source_code_id,p_dialing_method
437: from iec_g_list_subsets a,
438: ams_act_lists b,
439: AMS_CAMPAIGN_SCHEDULES_B c,
440: ams_list_headers_all d,
441: ams_source_codes code
442: where
443: a.list_header_id = b.list_header_id AND