APPS.BIX_CALL_UPDATE_PKG dependencies on AMS_SOURCE_CODES

Line 396: FROM ams_source_codes

392: --For AI calls use the source_code from interactions table
393: --
394: SELECT source_code_id, ARC_SOURCE_CODE_FOR
395: INTO p_source_code_id, l_source_code_for
396: FROM ams_source_codes
397: WHERE source_code = p_source_code;
398:
399: if l_source_code_for = 'CAMP' then
400: select campaign_id

Line 433: ams_source_codes code

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
436: b.list_used_by_id = c.schedule_id AND
437: b.list_act_type = 'TARGET' AND