APPS.AMS_LIST_UTIL_PKG dependencies on AMS_LIST_HEADERS_ALL

Line 32: FROM ams_list_cont_restrictions acr , ams_list_headers_all alh

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
32: FROM ams_list_cont_restrictions acr , ams_list_headers_all alh
33: WHERE acr.list_header_id = alh.list_header_id
34: and alh.status_code not in ('DRAFT','CANCELLED','ARCHIVED')
35: and alh.list_type = 'SUPPRESSION'
36: and ( acr.do_not_contact_flag = 'Y'

Line 110: FROM ams_list_cont_restrictions acr , ams_list_headers_all alh

106: and ac.schedule_id = p_object_id;
107:
108: cursor c_get_list(cur_campaign_id number, cur_media_id number) is
109: SELECT acr.list_header_id
110: FROM ams_list_cont_restrictions acr , ams_list_headers_all alh
111: WHERE acr.list_header_id = alh.list_header_id
112: and alh.status_code not in ('DRAFT','CANCELLED','ARCHIVED')
113: and alh.list_type = 'SUPPRESSION'
114: and ( acr.do_not_contact_flag = 'Y'