APPS.OEP_CMERGE_OESET dependencies on RA_CUSTOMER_MERGES

Line 16: from ra_customer_merges m

12: CURSOR c1 is
13: select agreement_id
14: from so_agreements
15: where invoice_to_site_use_id in (select m.duplicate_site_id
16: from ra_customer_merges m
17: where m.process_flag = 'N'
18: and m.request_id = req_id
19: and m.set_number = set_num)
20: for update nowait;

Line 26: from ra_customer_merges m

22: CURSOR c2 is
23: select agreement_id
24: from so_agreements
25: where customer_id in (select m.duplicate_id
26: from ra_customer_merges m
27: where m.process_flag = 'N'
28: and m.request_id = req_id
29: and m.set_number = set_num)
30: for update nowait;

Line 61: from ra_customer_merges m

57: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );
58:
59: UPDATE SO_AGREEMENTS a
60: set (invoice_to_site_use_id) = (select distinct m.customer_site_id
61: from ra_customer_merges m
62: where a.invoice_to_site_use_id =
63: m.duplicate_site_id
64: and m.request_id = req_id
65: and m.process_flag = 'N'

Line 71: from ra_customer_merges m

67: last_update_date = sysdate,
68: last_updated_by = arp_standard.profile.user_id,
69: last_update_login = arp_standard.profile.last_update_login
70: where invoice_to_site_use_id in (select m.duplicate_site_id
71: from ra_customer_merges m
72: where m.process_flag = 'N'
73: and m.request_id = req_id
74: and m.set_number = set_num);
75:

Line 87: from ra_customer_merges m

83: arp_message.set_token( 'TABLE_NAME', 'SO_AGREEMENTS', FALSE );
84:
85: UPDATE SO_AGREEMENTS a
86: set customer_id = (select distinct m.customer_id
87: from ra_customer_merges m
88: where a.customer_id =
89: m.duplicate_id
90: and m.process_flag = 'N'
91: and m.request_id = req_id

Line 97: from ra_customer_merges m

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