APPS.AMS_REFRESHMETRIC_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 191: FROM ams_campaign_schedules_b

187: -- 06/23/2001 huili added
188: --check the parent campaign for schedule
189: CURSOR c_check_parent_schedule (l_act_metric_used_by_id NUMBER) IS
190: SELECT campaign_id
191: FROM ams_campaign_schedules_b
192: WHERE schedule_id = l_act_metric_used_by_id;
193:
194: CURSOR c_check_parent_one_event(l_act_metric_used_by_id NUMBER) IS
195: SELECT parent_id

Line 1223: FROM ams_campaign_schedules_b

1219: AND status_code = 'CANCELLED';
1220:
1221: CURSOR c_csch(id NUMBER) IS
1222: SELECT Fnd_Api.G_TRUE
1223: FROM ams_campaign_schedules_b
1224: WHERE schedule_id = id
1225: AND status_code = 'CANCELLED';
1226:
1227: CURSOR c_delv(id NUMBER) IS

Line 2524: FROM AMS_CAMPAIGN_SCHEDULES_B

2520: WHERE campaign_id = p_campaign_id;
2521:
2522: CURSOR c_get_csch_setup(p_schedule_id NUMBER) IS
2523: SELECT custom_setup_id
2524: FROM AMS_CAMPAIGN_SCHEDULES_B
2525: WHERE schedule_id = p_schedule_id;
2526:
2527: CURSOR c_get_eveh_setup(p_event_id NUMBER) IS
2528: SELECT setup_type_id