APPS.AMS_ACT_LIST_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_VL

Line 1104: from ams_act_lists a, ams_campaign_schedules_vl b

1100: l_object_version_number NUMBER;
1101:
1102: cursor c1 is
1103: select 'x'
1104: from ams_act_lists a, ams_campaign_schedules_vl b
1105: where act_list_header_id = p_act_list_header_id
1106: and a.list_used_by_id = b.schedule_id
1107: and a.list_used_by = 'CSCH'
1108: and b.status_code = 'ACTIVE'

Line 2461: from ams_campaign_schedules_vl sc

2457: ) IS
2458:
2459: Cursor c_camp_source_code(cur_list_used_by_id number) is
2460: select sc.campaign_id , sc.use_parent_code_flag
2461: from ams_campaign_schedules_vl sc
2462: where sc.SCHEDULE_ID = cur_list_used_by_id ;
2463:
2464: l_source_code_flag varchar2(1) := 'N' ;
2465: l_source_id number;

Line 3895: from ams_act_lists a, ams_list_headers_vl b, ams_campaign_schedules_vl c

3891: b.CTRL_CONF_LEVEL, b.CTRL_REQ_RESP_RATE, b.CTRL_LIMIT_OF_ERROR, b.STATUS_CODE_OLD, b.CTRL_CONC_JOB_ID, b.CTRL_STATUS_CODE, b.CTRL_GEN_MODE, b.APPLY_SUPPRESSION_FLAG,
3892: -- end ckapoor R12 copy tg enhancements
3893: c.schedule_name || ' - ' || c.source_code list_name1
3894: ,b.main_random_pct_row_selection,b.row_selection_type,b.no_of_rows_max_requested --rmbhanda bug#4667513
3895: from ams_act_lists a, ams_list_headers_vl b, ams_campaign_schedules_vl c
3896: where a.list_used_by = p_list_used_by
3897: and a.list_used_by_id = p_from_schedule_id
3898: and a.list_act_type = l_list_type
3899: and a.list_header_id = b.list_header_id

Line 3915: from ams_campaign_schedules_vl a

3911:
3912: cursor c_get_schedule_details is
3913: select
3914: a.tgrp_exclude_prev_flag
3915: from ams_campaign_schedules_vl a
3916: where a.schedule_id = p_from_schedule_id ;
3917: l_target_group_rec c_get_target_group%rowtype;
3918:
3919: l_listheader_rec ams_listheader_pvt.list_header_rec_type;

Line 3946: from ams_campaign_schedules_vl c

3942: l_list_rule_id NUMBER;
3943:
3944: cursor c_new_schedule_details is
3945: select c.SCHEDULE_ID,c.SOURCE_CODE,c.SCHEDULE_NAME,c.schedule_name || ' - ' || c.source_code list_name
3946: from ams_campaign_schedules_vl c
3947: where c.schedule_id = p_to_schedule_id;
3948:
3949: CURSOR c_get_query_templete_type(p_templete_id IN NUMBER) is
3950: SELECT template_type