APPS.AMS_TCOP_SUMMARIZATION_PKG dependencies on AMS_LIST_ENTRIES

Line 78: ams_list_entries list_entry

74: delete from ams_tcop_contact_sum_dtl
75: where contact_summary_id in
76: (select summary.contact_summary_id
77: from ams_tcop_contact_summary summary,
78: ams_list_entries list_entry
79: where list_entry.enabled_flag = 'Y'
80: and list_entry.list_header_id = p_list_header_id
81: and list_entry.party_id = summary.party_id );
82:

Line 86: from ams_list_entries

82:
83: delete from ams_tcop_contact_summary
84: where party_id in
85: (select party_id
86: from ams_list_entries
87: where enabled_flag = 'Y'
88: and list_header_id = p_list_header_id);
89:
90: -- Delete the records for (party_id,media_id) combination

Line 95: ams_list_entries list_entry

91: delete from ams_tcop_channel_sum_dtl
92: where channel_summary_id in
93: (select summary.channel_summary_id
94: from ams_tcop_channel_summary summary,
95: ams_list_entries list_entry
96: where list_entry.party_id = summary.party_id
97: and list_entry.list_header_id = p_list_header_id
98: and summary.media_id = p_activity_id
99: and list_entry.enabled_flag = 'Y');

Line 105: ams_list_entries list_entry

101: delete from ams_tcop_channel_summary
102: where party_id in
103: (select summary.PARTY_ID
104: from ams_tcop_channel_summary summary,
105: ams_list_entries list_entry
106: where list_entry.party_id = summary.party_id
107: and list_entry.list_header_id = p_list_header_id
108: and summary.media_id = p_activity_id
109: and list_entry.enabled_flag = 'Y');

Line 159: FROM AMS_TCOP_CONTACTS contact, AMS_LIST_ENTRIES list_entry

155: p_no_of_days NUMBER)
156: IS
157: SELECT contact.party_id,
158: contact.schedule_id
159: FROM AMS_TCOP_CONTACTS contact, AMS_LIST_ENTRIES list_entry
160: WHERE contact.MEDIA_ID = p_activity_id
161: AND (contact_date between (sysdate - p_no_of_days) and sysdate)
162: AND contact.PARTY_ID = list_entry.PARTY_ID
163: AND list_entry.list_header_id = p_list_header_id

Line 173: FROM AMS_TCOP_CONTACTS contact, AMS_LIST_ENTRIES list_entry

169: CURSOR C_GET_GLOBAL_SUMMARY (p_list_header_id NUMBER, p_no_of_days NUMBER)
170: IS
171: SELECT contact.party_id,
172: contact.schedule_id
173: FROM AMS_TCOP_CONTACTS contact, AMS_LIST_ENTRIES list_entry
174: WHERE (contact_date between (sysdate - p_no_of_days) and sysdate)
175: AND contact.PARTY_ID = list_entry.PARTY_ID
176: AND list_entry.list_header_id = p_list_header_id
177: AND list_entry.enabled_flag = 'Y'