APPS.CCT_SERVERDATAINPUT_PUB dependencies on AMS_CAMPAIGNS_ALL_TL

Line 351: FROM ams_campaigns_all_tl

347: DECLARE
348: CURSOR campaign_id_cur (v_campaign_name IN VARCHAR2)
349: IS
350: SELECT campaign_id
351: FROM ams_campaigns_all_tl
352: WHERE UPPER (campaign_name) = UPPER (v_campaign_name)
353: ORDER BY campaign_id;
354: BEGIN
355: OPEN campaign_id_cur (p_campaign_name);