APPS.QP_CUST_MRG_DATA_CLEANUP dependencies on OE_AGREEMENTS_B

Line 12: from oe_agreements_b

8:
9: CURSOR c1
10: IS
11: select agreement_id
12: from oe_agreements_b
13: where invoice_to_org_id in (select m.duplicate_site_id
14: from ra_customer_merges m
15: where m.process_flag = 'Y'
16: and m.request_id = req_id

Line 23: from oe_agreements_b

19:
20: CURSOR c2
21: IS
22: select agreement_id
23: from oe_agreements_b
24: where sold_to_org_id in (select m.duplicate_id
25: from ra_customer_merges m
26: where m.process_flag = 'Y'
27: and m.request_id = req_id

Line 41: oe_debug_pub.add('Locking Table OE_AGREEMENTS_B');

37: **************************************************/
38:
39: IF (process_mode = 'LOCK') THEN
40:
41: oe_debug_pub.add('Locking Table OE_AGREEMENTS_B');
42:
43: open c1;
44: close c1;
45:

Line 53: oe_debug_pub.add('Updating Table OE_AGREEMENTS_B for Customer Site Data');

49: ELSE
50:
51: /** site level update **/
52:
53: oe_debug_pub.add('Updating Table OE_AGREEMENTS_B for Customer Site Data');
54:
55: UPDATE oe_agreements_b a
56: SET (invoice_to_org_id) = (select distinct m.customer_site_id
57: from ra_customer_merges m

Line 55: UPDATE oe_agreements_b a

51: /** site level update **/
52:
53: oe_debug_pub.add('Updating Table OE_AGREEMENTS_B for Customer Site Data');
54:
55: UPDATE oe_agreements_b a
56: SET (invoice_to_org_id) = (select distinct m.customer_site_id
57: from ra_customer_merges m
58: where a.invoice_to_org_id = m.duplicate_site_id
59: and m.request_id = req_id

Line 78: oe_debug_pub.add('Updating Table OE_AGREEMENTS_B for Customer Data');

74: oe_debug_pub.add(g_count || ' rows updated');
75:
76: /**customer level update**/
77:
78: oe_debug_pub.add('Updating Table OE_AGREEMENTS_B for Customer Data');
79:
80: UPDATE oe_agreements_b a
81: SET sold_to_org_id = (select distinct m.customer_id
82: from ra_customer_merges m

Line 80: UPDATE oe_agreements_b a

76: /**customer level update**/
77:
78: oe_debug_pub.add('Updating Table OE_AGREEMENTS_B for Customer Data');
79:
80: UPDATE oe_agreements_b a
81: SET sold_to_org_id = (select distinct m.customer_id
82: from ra_customer_merges m
83: where a.sold_to_org_id = m.duplicate_id
84: and m.process_flag = 'Y'