APPS.AMS_WFTRIG_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 1474: FROM ams_campaign_schedules_b

1470: l_timezone NUMBER;
1471:
1472: CURSOR c_sch_det (p_schedule_id NUMBER) IS
1473: SELECT start_date_time, timezone_id
1474: FROM ams_campaign_schedules_b
1475: WHERE schedule_id = p_schedule_id;
1476: -- end soagrawa 26-sep-2003
1477:
1478: BEGIN

Line 2551: from ams_Campaign_schedules_b

2547: l_sch_det_rec c_sch_det%ROWTYPE;
2548:
2549: CURSOR c_sch_all_det(l_trig_id NUMBER) IS
2550: select distinct nvl(orig_csch_id, schedule_id) AS id, count(*) AS total
2551: from ams_Campaign_schedules_b
2552: where trigger_id = l_trig_id
2553: and status_code = 'AVAILABLE'
2554: and trig_repeat_flag = 'Y'
2555: group by nvl(orig_csch_id, schedule_id);

Line 2561: from ams_campaign_schedules_b

2557: l_sch_all_det_rec c_sch_all_det%ROWTYPE;
2558:
2559: CURSOR c_max_sch_det(p_schedule_id NUMBER) IS
2560: select schedule_id
2561: from ams_campaign_schedules_b
2562: where creation_date = (select max(creation_date)
2563: from ams_campaign_schedules_b
2564: where nvl(orig_csch_id, schedule_id) = p_schedule_id);
2565:

Line 2563: from ams_campaign_schedules_b

2559: CURSOR c_max_sch_det(p_schedule_id NUMBER) IS
2560: select schedule_id
2561: from ams_campaign_schedules_b
2562: where creation_date = (select max(creation_date)
2563: from ams_campaign_schedules_b
2564: where nvl(orig_csch_id, schedule_id) = p_schedule_id);
2565:
2566: -- 18-feb-2004 soagrawa Fixed bug# 3452264
2567: CURSOR c_orig_csch_name(p_Schedule_id NUMBER) IS

Line 2571: From ams_campaign_Schedules_b

2567: CURSOR c_orig_csch_name(p_Schedule_id NUMBER) IS
2568: select schedule_name
2569: from ams_Campaign_schedules_vl
2570: where schedule_id = ( select nvl(orig_csch_id, schedule_id)
2571: From ams_campaign_Schedules_b
2572: where schedule_id = p_schedule_id);
2573:
2574: l_new_cover_letter_id NUMBER;
2575: l_ci_base_lang VARCHAR2(4);