APPS.XDP_PARTY_MERGE dependencies on RA_CUSTOMER_MERGES

Line 33: FROM XDP_ORDER_HEADERS yt, ra_customer_merges m

29: CURSOR merged_records IS
30: SELECT distinct CUSTOMER_MERGE_HEADER_ID
31: ,ORDER_ID
32: ,CUST_ACCOUNT_ID
33: FROM XDP_ORDER_HEADERS yt, ra_customer_merges m
34: WHERE (
35: yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
36: ) AND m.process_flag = 'N'
37: AND m.request_id = request_id

Line 57: FROM XDP_ORDER_LINE_ITEMS yt, ra_customer_merges m

53: CURSOR merged_records1 IS
54: SELECT distinct CUSTOMER_MERGE_HEADER_ID
55: ,LINE_ITEM_ID
56: ,SITE_USE_ID
57: FROM XDP_ORDER_LINE_ITEMS yt, ra_customer_merges m
58: WHERE (
59: yt.SITE_USE_ID = m.DUPLICATE_SITE_ID
60: ) AND m.process_flag = 'N'
61: AND m.request_id = request_id