APPS.AMS_CAMPAIGNRULES_PVT dependencies on DUAL

Line 175: -- FROM DUAL

171: AND using_object_type in ('EVEH', 'EVEO');
172:
173: -- CURSOR c_event_used IS
174: -- SELECT 1
175: -- FROM DUAL
176: -- WHERE EXISTS(
177: -- SELECT 1
178: -- FROM ams_object_associations
179: -- WHERE master_object_type = 'CAMP'

Line 320: FROM DUAL

316: WHERE campaign_id = p_campaign_id;
317:
318: CURSOR c_csch_exist IS
319: SELECT 1
320: FROM DUAL
321: WHERE EXISTS(
322: SELECT 1
323: FROM ams_campaign_schedules_b
324: WHERE campaign_id = p_campaign_id

Line 581: FROM DUAL

577: WHERE user_id = FND_GLOBAL.user_id ;
578:
579: CURSOR c_child IS
580: SELECT 1
581: FROM DUAL
582: WHERE EXISTS(
583: SELECT campaign_id
584: FROM ams_campaigns_vl
585: WHERE parent_campaign_id = p_camp_rec.campaign_id);

Line 893: FROM DUAL

889: WHERE event_offer_id = p_channel_id;
890:
891: CURSOR c_camp_event IS
892: SELECT 1
893: FROM DUAL
894: WHERE EXISTS(
895: SELECT campaign_id
896: FROM ams_campaigns_vl
897: WHERE media_type_code = 'EVENTS'

Line 1116: FROM DUAL

1112: l_dummy NUMBER;
1113:
1114: CURSOR c_campaign_calendar IS
1115: SELECT 1
1116: FROM DUAL
1117: WHERE EXISTS(
1118: SELECT 1
1119: FROM gl_periods_v
1120: WHERE period_set_name = p_campaign_calendar

Line 1254: FROM DUAL

1250:
1251:
1252: CURSOR c_displayed IS
1253: SELECT 1
1254: FROM DUAL
1255: WHERE EXISTS(
1256: SELECT 1
1257: FROM ams_campaigns_vl
1258: WHERE campaign_name = p_campaign_name

Line 1269: FROM DUAL

1265: );
1266:
1267: CURSOR c_duplicate IS
1268: SELECT 1
1269: FROM DUAL
1270: WHERE EXISTS(
1271: SELECT 1
1272: FROM ams_campaigns_vl
1273: WHERE campaign_name = p_campaign_name

Line 2432: FROM DUAL

2428: WHERE campaign_id = p_campaign_id;
2429:
2430: CURSOR c_budget_exist IS
2431: SELECT 1
2432: FROM DUAL
2433: WHERE EXISTS(
2434: SELECT 1
2435: FROM ozf_act_budgets
2436: WHERE arc_act_budget_used_by = 'CAMP'