APPS.AMS_SCHEDULER_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 225: from ams_campaign_schedules_b

221:
222: -- soagrawa added on 21-apr-2004 for bug# 3570234
223: CURSOR c_max_sch_det(p_schedule_id NUMBER) IS
224: select schedule_id
225: from ams_campaign_schedules_b
226: where creation_date = (select max(creation_date)
227: from ams_campaign_schedules_b
228: where nvl(orig_csch_id, schedule_id) = p_schedule_id);
229:

Line 227: from ams_campaign_schedules_b

223: CURSOR c_max_sch_det(p_schedule_id NUMBER) IS
224: select schedule_id
225: from ams_campaign_schedules_b
226: where creation_date = (select max(creation_date)
227: from ams_campaign_schedules_b
228: where nvl(orig_csch_id, schedule_id) = p_schedule_id);
229:
230: l_tgrp_copy_from_csch_id NUMBER;
231:

Line 587: UPDATE AMS_CAMPAIGN_SCHEDULES_B

583: OPEN c_def_status('AVAILABLE');
584: FETCH c_def_status INTO l_def_avail_status;
585: CLOSE c_def_status;
586:
587: UPDATE AMS_CAMPAIGN_SCHEDULES_B
588: SET STATUS_CODE = 'AVAILABLE' ,
589: status_date = sysdate,
590: user_status_id = l_def_avail_status
591: WHERE SCHEDULE_ID = l_new_sched_id;