APPS.OEP_CMERGE_OEHLD dependencies on STANDARD

Line 98: last_updated_by = arp_standard.profile.user_id,

94: and m.request_id = req_id
95: and m.process_flag = 'N'
96: and m.set_number = set_num),
97: last_update_date = sysdate,
98: last_updated_by = arp_standard.profile.user_id,
99: last_update_login = arp_standard.profile.last_update_login
100: where hold_entity_id in (select m.duplicate_site_id
101: from ra_customer_merges m
102: where m.process_flag = 'N'

Line 99: last_update_login = arp_standard.profile.last_update_login

95: and m.process_flag = 'N'
96: and m.set_number = set_num),
97: last_update_date = sysdate,
98: last_updated_by = arp_standard.profile.user_id,
99: last_update_login = arp_standard.profile.last_update_login
100: where hold_entity_id in (select m.duplicate_site_id
101: from ra_customer_merges m
102: where m.process_flag = 'N'
103: and m.request_id = req_id

Line 126: last_updated_by = arp_standard.profile.user_id,

122: and m.request_id = req_id
123: and m.process_flag = 'N'
124: and m.set_number = set_num),
125: last_update_date = sysdate,
126: last_updated_by = arp_standard.profile.user_id,
127: last_update_login = arp_standard.profile.last_update_login
128: where hold_entity_id in (select m.duplicate_site_id
129: from ra_customer_merges m
130: where m.process_flag = 'N'

Line 127: last_update_login = arp_standard.profile.last_update_login

123: and m.process_flag = 'N'
124: and m.set_number = set_num),
125: last_update_date = sysdate,
126: last_updated_by = arp_standard.profile.user_id,
127: last_update_login = arp_standard.profile.last_update_login
128: where hold_entity_id in (select m.duplicate_site_id
129: from ra_customer_merges m
130: where m.process_flag = 'N'
131: and m.request_id = req_id

Line 154: last_updated_by = arp_standard.profile.user_id,

150: and m.request_id = req_id
151: and m.process_flag = 'N'
152: and m.set_number = set_num),
153: last_update_date = sysdate,
154: last_updated_by = arp_standard.profile.user_id,
155: last_update_login = arp_standard.profile.last_update_login
156: where hold_entity_id in (select m.duplicate_site_id
157: from ra_customer_merges m
158: where m.process_flag = 'N'

Line 155: last_update_login = arp_standard.profile.last_update_login

151: and m.process_flag = 'N'
152: and m.set_number = set_num),
153: last_update_date = sysdate,
154: last_updated_by = arp_standard.profile.user_id,
155: last_update_login = arp_standard.profile.last_update_login
156: where hold_entity_id in (select m.duplicate_site_id
157: from ra_customer_merges m
158: where m.process_flag = 'N'
159: and m.request_id = req_id

Line 182: last_updated_by = arp_standard.profile.user_id,

178: and m.process_flag = 'N'
179: and m.request_id = req_id
180: and m.set_number = set_num),
181: last_update_date = sysdate,
182: last_updated_by = arp_standard.profile.user_id,
183: last_update_login = arp_standard.profile.last_update_login
184: where hold_entity_id in (select m.duplicate_id
185: from ra_customer_merges m
186: where m.process_flag = 'N'

Line 183: last_update_login = arp_standard.profile.last_update_login

179: and m.request_id = req_id
180: and m.set_number = set_num),
181: last_update_date = sysdate,
182: last_updated_by = arp_standard.profile.user_id,
183: last_update_login = arp_standard.profile.last_update_login
184: where hold_entity_id in (select m.duplicate_id
185: from ra_customer_merges m
186: where m.process_flag = 'N'
187: and m.request_id = req_id