APPS.AST_UWQ_SEL_PKG dependencies on AMS_ACT_CONTACT_POINTS

Line 479: FROM aMS_SOURCE_CODES SOC, AMS_ACT_CONTACT_POINTS AACP

475: PROCEDURE Getcampaigncode IS
476:
477: CURSOR c_campaignId(x_inbound_phone VARCHAR2) IS
478: SELECT SOC.SOURCE_CODE_ID, SOC.SOURCE_CODE
479: FROM aMS_SOURCE_CODES SOC, AMS_ACT_CONTACT_POINTS AACP
480: WHERE SOC.SOURCE_CODE_FOR_ID = AACP.ACT_CONTACT_USED_BY_ID AND
481: SOC.ARC_SOURCE_CODE_FOR = AACP.ARC_CONTACT_USED_BY AND
482: SOC.ACTIVE_FLAG = 'Y' AND AACP.CONTACT_POINT_TYPE = 'PHONE'
483: AND AACP.CONTACT_POINT_VALUE = x_inbound_phone;