APPS.AMS_LIST_UTIL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

  select  ac.campaign_id
    from ams_campaign_schedules_vl ac
   where ac.schedule_id = p_object_id;

Line: 31

         SELECT acr.list_header_id
           FROM ams_list_cont_restrictions acr , ams_list_headers_all alh
          WHERE acr.list_header_id  =  alh.list_header_id
            and alh.status_code not in ('DRAFT','CANCELLED','ARCHIVED')
            and alh.list_type = 'SUPPRESSION'
            and (   acr.do_not_contact_flag = 'Y'
                 or acr.list_used_by_id = cur_campaign_id
                 or acr.media_id = 20
                 ) ;

Line: 63

           x_where_clause  := 'select ale_01.party_id ' ||
                              'from  ams_list_entries ale_01 '||
                              'where ' || l_string ;

Line: 102

  select am.dedupe_rule_id, ac.campaign_id, am.media_id
    from ams_campaign_schedules_vl ac, ams_media_vl am
   where ac.activity_id = am.media_id
   and am.dedupe_rule_id is not null
   and ac.schedule_id = p_object_id;

Line: 109

         SELECT acr.list_header_id
           FROM ams_list_cont_restrictions acr , ams_list_headers_all alh
          WHERE acr.list_header_id  =  alh.list_header_id
            and alh.status_code not in ('DRAFT','CANCELLED','ARCHIVED')
            and alh.list_type = 'SUPPRESSION'
            and (   acr.do_not_contact_flag = 'Y'
                 or acr.list_used_by_id = cur_campaign_id
                 or acr.media_id = cur_media_id) ;

Line: 119

         SELECT field_column_name
           FROM ams_list_rule_fields
          WHERE list_rule_id =  cur_rule_id;

Line: 129

     l_string := ' and not exists ( select '||''''|| 'x'||'''';