APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_CAMPAIGNS_VL

Line 531: FROM ams_campaigns_vl

527:
528: CURSOR c_camp IS
529: SELECT source_code,
530: global_flag
531: FROM ams_campaigns_vl
532: WHERE campaign_id = p_camp_id;
533:
534: l_source_code VARCHAR2(30);
535: l_dummy_src_code VARCHAR2(50);

Line 847: FROM ams_campaigns_vl

843:
844: CURSOR c_camp IS
845: SELECT source_code,
846: global_flag
847: FROM ams_campaigns_vl
848: WHERE campaign_id = p_schedule_rec.campaign_id;
849:
850: BEGIN
851: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1380: -- FROM ams_campaigns_vl

1376: -- SELECT 1
1377: -- FROM DUAL
1378: -- WHERE EXISTS(
1379: -- SELECT campaign_id
1380: -- FROM ams_campaigns_vl
1381: -- WHERE media_type_code = 'EVENTS'
1382: -- AND arc_channel_from = p_arc_channel_from
1383: -- AND channel_id = p_channel_id
1384: -- AND (campaign_id <> p_campaign_id OR p_campaign_id IS NULL));