APPS.AMS_TCOP_UTIL_PKG SQL Statements

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

Line: 36

select list_header.apply_traffic_cop,
       list_header.list_header_id
from ams_list_headers_all list_header
,ams_act_lists act_list
where act_list.LIST_ACT_TYPE = 'TARGET'
and act_list.LIST_USED_BY = 'CSCH'
and act_list.LIST_USED_BY_ID = p_schedule_id
and act_list.LIST_HEADER_ID = list_header.LIST_HEADER_ID;

Line: 47

select rule_id
from ams_tcop_fr_rules_setup rule,
     ams_campaign_schedules_b schedule
where rule.ENABLED_FLAG = 'Y'
and (rule.CHANNEL_ID is null
     or (rule.CHANNEL_ID = schedule.ACTIVITY_ID) )
and rule.RULE_TYPE in ('GLOBAL' , 'CHANNEL_BASED')
and schedule.SCHEDULE_ID = p_schedule_id;

Line: 58

select list1.list_entry_id
from ams_list_entries list1
where list1.list_header_id = p_list_header_id
and exists
(
   select list2.list_entry_id
   from ams_list_entries list2
   where list1.list_entry_id=list2.list_entry_id
   and list2.list_header_id = p_list_header_id
   and list2.party_id is null
);

Line: 72

select list1.list_entry_id
from ams_list_entries list1
where list1.list_header_id=p_list_header_id
and not exists
(
   select list2.party_id
   from ams_list_entries list2
        ,hz_parties hz
   where list2.party_id=hz.party_id
   and list2.list_header_id = p_list_header_id
   and list2.list_entry_id=list1.list_entry_id
);