23:
24:
25: cursor c_get_camp_id is
26: select ac.campaign_id
27: from ams_campaign_schedules_vl ac
28: where ac.schedule_id = p_object_id;
29:
30: cursor c_get_list(cur_campaign_id number) is
31: SELECT acr.list_header_id
99:
100:
101: cursor c_get_rule_id is
102: select am.dedupe_rule_id, ac.campaign_id, am.media_id
103: from ams_campaign_schedules_vl ac, ams_media_vl am
104: where ac.activity_id = am.media_id
105: and am.dedupe_rule_id is not null
106: and ac.schedule_id = p_object_id;
107: