APPS.AMS_FULFILL_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 414: FROM ams_campaign_schedules_b

410: l_return_status VARCHAR2(1);
411:
412: CURSOR c_csch_det IS
413: SELECT sender_display_name,mail_subject,source_code, start_Date_time,mail_sender_name,reply_to_mail, owner_user_id, activity_id, printer_address, delivery_mode
414: FROM ams_campaign_schedules_b
415: WHERE schedule_id = p_schedule_id ;
416:
417: -- following cursor added by soagrawa on 15-jul-2002
418: CURSOR c_csch_source_code(l_id IN VARCHAR2) IS

Line 1045: FROM ams_campaign_schedules_b csch,jtf_amv_items_vl item

1041: CURSOR c_csch_det IS
1042: SELECT csch.campaign_id,csch.cover_letter_id cover_letter,item.item_name name,
1043: csch.mail_sender_name, csch.reply_to_mail replyto_mail_id, csch.from_fax_no,
1044: csch.activity_type_code, csch.activity_id
1045: FROM ams_campaign_schedules_b csch,jtf_amv_items_vl item
1046: WHERE schedule_id = p_schedule_id
1047: AND csch.cover_letter_id = item.item_id ;
1048: l_camp_id NUMBER;
1049:

Line 1484: -- FROM ams_campaign_schedules_b csch, ams_deliverables_vl deli, ams_object_associations assoc

1480: --CURSOR c_csch_det IS
1481: -- SELECT deli.jtf_amv_item_id,deli.kit_flag,deli.deliverable_name,
1482: -- deli.can_fulfill_electronic_flag,
1483: -- csch.activity_type_code, csch.activity_id
1484: -- FROM ams_campaign_schedules_b csch, ams_deliverables_vl deli, ams_object_associations assoc
1485: -- WHERE csch.schedule_id = p_act_id
1486: -- AND assoc.master_object_type = 'CSCH'
1487: -- AND assoc.master_object_id= p_act_id
1488: -- AND assoc.using_object_type = 'DELV'

Line 1494: FROM ams_campaign_schedules_b ams,jtf_amv_attachments jtf

1490:
1491: CURSOR c_csch_det IS
1492: SELECT jtf.file_id,jtf.file_name,
1493: ams.activity_type_code, ams.activity_id
1494: FROM ams_campaign_schedules_b ams,jtf_amv_attachments jtf
1495: -- modified by soagrawa, ptendulk on 06-Sep-2001
1496: -- WHERE jtf.attachment_used_by = p_arc_act
1497: WHERE jtf.attachment_used_by = 'AMS_'||p_arc_act
1498: AND jtf.attachment_used_by_id = ams.schedule_id

Line 1943: FROM ams_campaign_schedules_b

1939: -- ==============================================================================
1940:
1941: CURSOR c_subject IS
1942: SELECT mail_subject,source_code
1943: FROM ams_campaign_schedules_b
1944: WHERE schedule_id = p_schedule_id ;
1945: l_subject VARCHAR2(1000) ;
1946: l_source_code VARCHAR2(30);
1947:

Line 2345: FROM ams_campaign_schedules_b csch,jtf_amv_items_vl item

2341: CURSOR c_csch_det IS
2342: SELECT csch.campaign_id, csch.cover_letter_id cover_letter,item.item_name name,
2343: csch.mail_sender_name, csch.reply_to_mail ,
2344: csch.mail_subject
2345: FROM ams_campaign_schedules_b csch,jtf_amv_items_vl item
2346: WHERE schedule_id = p_schedule_id
2347: AND csch.cover_letter_id = item.item_id ;
2348: l_schedule_rec c_csch_det%ROWTYPE;
2349: