APPS.AMS_WFTRIG_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_VL

Line 74: FROM ams_campaign_schedules_vl

70: WHERE campaign_id = p_activity_id ;
71:
72: CURSOR c_csch_det IS
73: SELECT owner_user_id
74: FROM ams_campaign_schedules_vl
75: WHERE schedule_id = p_activity_id ;
76:
77: CURSOR c_deli_det IS
78: SELECT owner_user_id

Line 1718: FROM ams_campaign_schedules_vl

1714: l_display_name VARCHAR2(30);
1715:
1716: CURSOR c_sch_det(l_trig_id NUMBER) IS
1717: SELECT schedule_id, notify_user_id, approver_user_id, owner_user_id, schedule_name
1718: FROM ams_campaign_schedules_vl
1719: WHERE trigger_id = l_trig_id
1720: AND status_code = 'AVAILABLE'
1721: -- soagrawa 28-apr-2003 added the following to this cursor
1722: AND (trig_repeat_flag IS NULL OR trig_repeat_flag = 'N');

Line 1981: FROM ams_campaign_schedules_vl

1977: result OUT NOCOPY VARCHAR2)
1978: IS
1979: CURSOR c_sch_count(l_trig_id NUMBER) IS
1980: SELECT count(1)
1981: FROM ams_campaign_schedules_vl
1982: WHERE trigger_id = l_trig_id
1983: AND status_code = 'AVAILABLE';
1984:
1985:

Line 2536: from ams_campaign_schedules_vl

2532: FROM dual;
2533: */
2534: CURSOR c_sched_rec (l_sched_id IN NUMBER) IS
2535: SELECT *
2536: from ams_campaign_schedules_vl
2537: where schedule_id = l_sched_id;
2538:
2539: l_csch_rec c_sched_rec%ROWTYPE;
2540: --end additions by cgoyal on 6/may/03

Line 2544: FROM ams_campaign_schedules_vl

2540: --end additions by cgoyal on 6/may/03
2541:
2542: CURSOR c_sch_det(p_schedule_id NUMBER) IS
2543: SELECT schedule_id, notify_user_id, approver_user_id, owner_user_id, schedule_name
2544: FROM ams_campaign_schedules_vl
2545: WHERE schedule_id = p_schedule_id;
2546:
2547: l_sch_det_rec c_sch_det%ROWTYPE;
2548:

Line 2569: from ams_Campaign_schedules_vl

2565:
2566: -- 18-feb-2004 soagrawa Fixed bug# 3452264
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:

Line 3388: FROM ams_campaign_schedules_vl

3384: WHERE campaign_id = l_trig_rec.trigger_created_for_id ;
3385:
3386: CURSOR c_csch_det IS
3387: SELECT schedule_name, priority, owner_user_id
3388: FROM ams_campaign_schedules_vl
3389: WHERE schedule_id = l_trig_rec.trigger_created_for_id ;
3390:
3391: CURSOR c_eveo_eone_det IS
3392: SELECT event_offer_name, 'STANDARD', owner_user_id