APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_SOURCE_CODES

Line 475: ams_source_codes_gen_s.NEXTVAL,

471: scode_char_element,
472: scode_number_element,
473: arc_source_code_for
474: ) VALUES (
475: ams_source_codes_gen_s.NEXTVAL,
476: SYSDATE,
477: FND_GLOBAL.user_id,
478: SYSDATE,
479: FND_GLObAL.user_id,

Line 668: FROM ams_source_codes

664: l_msg_data VARCHAR2(2000);
665:
666: CURSOR c_source_code IS
667: SELECT 1
668: FROM ams_source_codes
669: WHERE source_code = p_schedule_rec.source_code
670: AND active_flag = 'Y';
671:
672: CURSOR c_schedule IS

Line 828: FROM ams_source_codes

824: l_camp_global_flag VARCHAR2(1);
825:
826: CURSOR c_source_code IS
827: SELECT 1
828: FROM ams_source_codes
829: WHERE source_code = p_schedule_rec.source_code
830: AND active_flag = 'Y';
831:
832: CURSOR c_schedule IS

Line 4459: from ams_campaign_schedules_b a, ams_source_codes b

4455: and nvl(cat.PURCHASE_INTEREST, 'Y') <> 'N';
4456:
4457: cursor c_schedule_details_csr(p_schedule_id NUMBER) is
4458: select a.source_code, a.sales_methodology_id, b.source_code_id
4459: from ams_campaign_schedules_b a, ams_source_codes b
4460: where a.schedule_id = p_schedule_id
4461: and a.status_code = 'ACTIVE'
4462: and a.source_code = b.source_code;
4463: