93: and m.request_id = req_id
94: and m.process_flag = 'N'
95: and m.set_number = set_num),
96: last_update_date = sysdate,
97: last_updated_by = arp_standard.profile.user_id,
98: last_update_login = arp_standard.profile.last_update_login
99: where entity_value in (select to_char(m.duplicate_site_id)
100: from ra_customer_merges m
101: where m.process_flag = 'N'
94: and m.process_flag = 'N'
95: and m.set_number = set_num),
96: last_update_date = sysdate,
97: last_updated_by = arp_standard.profile.user_id,
98: last_update_login = arp_standard.profile.last_update_login
99: where entity_value in (select to_char(m.duplicate_site_id)
100: from ra_customer_merges m
101: where m.process_flag = 'N'
102: and m.request_id = req_id
121: and m.request_id = req_id
122: and m.process_flag = 'N'
123: and m.set_number = set_num),
124: last_update_date = sysdate,
125: last_updated_by = arp_standard.profile.user_id,
126: last_update_login = arp_standard.profile.last_update_login
127: where entity_value in (select to_char(m.duplicate_site_id)
128: from ra_customer_merges m
129: where m.process_flag = 'N'
122: and m.process_flag = 'N'
123: and m.set_number = set_num),
124: last_update_date = sysdate,
125: last_updated_by = arp_standard.profile.user_id,
126: last_update_login = arp_standard.profile.last_update_login
127: where entity_value in (select to_char(m.duplicate_site_id)
128: from ra_customer_merges m
129: where m.process_flag = 'N'
130: and m.request_id = req_id
149: and m.request_id = req_id
150: and m.process_flag = 'N'
151: and m.set_number = set_num),
152: last_update_date = sysdate,
153: last_updated_by = arp_standard.profile.user_id,
154: last_update_login = arp_standard.profile.last_update_login
155: where entity_value in (select to_char(m.duplicate_site_id)
156: from ra_customer_merges m
157: where m.process_flag = 'N'
150: and m.process_flag = 'N'
151: and m.set_number = set_num),
152: last_update_date = sysdate,
153: last_updated_by = arp_standard.profile.user_id,
154: last_update_login = arp_standard.profile.last_update_login
155: where entity_value in (select to_char(m.duplicate_site_id)
156: from ra_customer_merges m
157: where m.process_flag = 'N'
158: and m.request_id = req_id
177: and m.process_flag = 'N'
178: and m.request_id = req_id
179: and m.set_number = set_num),
180: last_update_date = sysdate,
181: last_updated_by = arp_standard.profile.user_id,
182: last_update_login = arp_standard.profile.last_update_login
183: where entity_value in (select to_char(m.duplicate_id)
184: from ra_customer_merges m
185: where m.process_flag = 'N'
178: and m.request_id = req_id
179: and m.set_number = set_num),
180: last_update_date = sysdate,
181: last_updated_by = arp_standard.profile.user_id,
182: last_update_login = arp_standard.profile.last_update_login
183: where entity_value in (select to_char(m.duplicate_id)
184: from ra_customer_merges m
185: where m.process_flag = 'N'
186: and m.request_id = req_id
268: and m.request_id = req_id
269: and m.process_flag = 'N'
270: and m.set_number = set_num),
271: last_update_date = sysdate,
272: last_updated_by = arp_standard.profile.user_id,
273: last_update_login = arp_standard.profile.last_update_login
274: where site_use_id in (select m.duplicate_site_id
275: from ra_customer_merges m
276: where m.process_flag = 'N'
269: and m.process_flag = 'N'
270: and m.set_number = set_num),
271: last_update_date = sysdate,
272: last_updated_by = arp_standard.profile.user_id,
273: last_update_login = arp_standard.profile.last_update_login
274: where site_use_id in (select m.duplicate_site_id
275: from ra_customer_merges m
276: where m.process_flag = 'N'
277: and m.request_id = req_id
294: and m.process_flag = 'N'
295: and m.request_id = req_id
296: and m.set_number = set_num),
297: last_update_date = sysdate,
298: last_updated_by = arp_standard.profile.user_id,
299: last_update_login = arp_standard.profile.last_update_login
300: where customer_id in (select m.duplicate_id
301: from ra_customer_merges m
302: where m.process_flag = 'N'
295: and m.request_id = req_id
296: and m.set_number = set_num),
297: last_update_date = sysdate,
298: last_updated_by = arp_standard.profile.user_id,
299: last_update_login = arp_standard.profile.last_update_login
300: where customer_id in (select m.duplicate_id
301: from ra_customer_merges m
302: where m.process_flag = 'N'
303: and m.request_id = req_id