APPS.BIX_CALL_LOAD_PKG dependencies on AMS_SOURCE_CODES

Line 405: FROM ams_source_codes

401: --For AI calls use the source_code from interactions table
402: --
403: SELECT source_code_id, ARC_SOURCE_CODE_FOR
404: INTO p_source_code_id, l_source_code_for
405: FROM ams_source_codes
406: WHERE source_code = p_source_code;
407:
408: if l_source_code_for = 'CAMP' then
409: select campaign_id

Line 441: ams_source_codes code

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