APPS.AMS_SCHEDULERULES_PVT dependencies on JTF_IH_MEDIA_ITEMS_S1

Line 2701: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL

2697: FROM ams_campaign_schedules_b
2698: WHERE schedule_id = p_schedule_id;
2699:
2700: CURSOR c_media_item_id IS
2701: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL
2702: FROM dual;
2703:
2704: CURSOR c_interactions_id IS
2705: SELECT jtf_ih_interactions_s1.NEXTVAL

Line 2741: -- l_media_rec.media_id := JTF_IH_MEDIA_ITEMS_S1.nextval;

2737: -- populate media_rec
2738: OPEN c_media_item_id;
2739: FETCH c_media_item_id INTO l_media_rec.media_id ;
2740: CLOSE c_media_item_id;
2741: -- l_media_rec.media_id := JTF_IH_MEDIA_ITEMS_S1.nextval;
2742: l_media_rec.end_date_time := l_schedule_end_time ;
2743: l_media_rec.start_date_time := l_schedule_start_time ;
2744: l_media_rec.media_item_type := 'MAIL' ;
2745: