APPS.IEX_UWQ_SEL_PKG dependencies on AMS_CAMPAIGNS_ALL_B

Line 304: FROM ams_campaigns_all_b

300: PROCEDURE getcampaigncode IS
301:
302: CURSOR c_campaignId(x_inbound_phone VARCHAR2) IS
303: SELECT campaign_id
304: FROM ams_campaigns_all_b
305: WHERE translate(inbound_phone_no,'0123456789()/\-. ','0123456789')=x_inbound_phone
306: AND status_code ='ACTIVE';
307:
308: CURSOR c_campaigncode(x_campaigncode VARCHAR2) IS