APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on AMS_SOURCE_CODES

Line 448: select ARC_SOURCE_CODE_FOR into sc_code from ams_source_codes

444:
445:
446: BEGIN
447:
448: select ARC_SOURCE_CODE_FOR into sc_code from ams_source_codes
449: where source_code = p_source_code;
450:
451: return sc_code;
452:

Line 467: select ARC_SOURCE_CODE_FOR into v_sc_code from ams_source_codes

463:
464: v_sc_code varchar2(10);
465: begin
466:
467: select ARC_SOURCE_CODE_FOR into v_sc_code from ams_source_codes
468: where source_code = p_source_code;
469:
470: if v_sc_code = 'CAMP' then
471: select campaign_id into p_campaign_id