95: and m.request_id = req_id
96: and m.process_flag = 'N'
97: and m.set_number = set_num),
98: last_update_date = sysdate,
99: last_updated_by = arp_standard.profile.user_id,
100: last_update_login = arp_standard.profile.last_update_login
101: where entity_value in (select m.duplicate_site_id
102: from ra_customer_merges m
103: where m.process_flag = 'N'
96: and m.process_flag = 'N'
97: and m.set_number = set_num),
98: last_update_date = sysdate,
99: last_updated_by = arp_standard.profile.user_id,
100: last_update_login = arp_standard.profile.last_update_login
101: where entity_value in (select m.duplicate_site_id
102: from ra_customer_merges m
103: where m.process_flag = 'N'
104: and m.request_id = req_id
123: and m.request_id = req_id
124: and m.process_flag = 'N'
125: and m.set_number = set_num),
126: last_update_date = sysdate,
127: last_updated_by = arp_standard.profile.user_id,
128: last_update_login = arp_standard.profile.last_update_login
129: where entity_value in (select m.duplicate_site_id
130: from ra_customer_merges m
131: where m.process_flag = 'N'
124: and m.process_flag = 'N'
125: and m.set_number = set_num),
126: last_update_date = sysdate,
127: last_updated_by = arp_standard.profile.user_id,
128: last_update_login = arp_standard.profile.last_update_login
129: where entity_value in (select m.duplicate_site_id
130: from ra_customer_merges m
131: where m.process_flag = 'N'
132: and m.request_id = req_id
151: and m.request_id = req_id
152: and m.process_flag = 'N'
153: and m.set_number = set_num),
154: last_update_date = sysdate,
155: last_updated_by = arp_standard.profile.user_id,
156: last_update_login = arp_standard.profile.last_update_login
157: where entity_value in (select m.duplicate_site_id
158: from ra_customer_merges m
159: where m.process_flag = 'N'
152: and m.process_flag = 'N'
153: and m.set_number = set_num),
154: last_update_date = sysdate,
155: last_updated_by = arp_standard.profile.user_id,
156: last_update_login = arp_standard.profile.last_update_login
157: where entity_value in (select m.duplicate_site_id
158: from ra_customer_merges m
159: where m.process_flag = 'N'
160: and m.request_id = req_id
179: and m.process_flag = 'N'
180: and m.request_id = req_id
181: and m.set_number = set_num),
182: last_update_date = sysdate,
183: last_updated_by = arp_standard.profile.user_id,
184: last_update_login = arp_standard.profile.last_update_login
185: where entity_value in (select m.duplicate_id
186: from ra_customer_merges m
187: where m.process_flag = 'N'
180: and m.request_id = req_id
181: and m.set_number = set_num),
182: last_update_date = sysdate,
183: last_updated_by = arp_standard.profile.user_id,
184: last_update_login = arp_standard.profile.last_update_login
185: where entity_value in (select m.duplicate_id
186: from ra_customer_merges m
187: where m.process_flag = 'N'
188: and m.request_id = req_id