DBA Data[Home] [Help]

APPS.DPP_ACCOUNT_MERGE_PVT dependencies on RA_CUSTOMER_MERGES

Line 49: FROM dpp_customer_claims_all yt, ra_customer_merges m

45: CURSOR merged_records IS
46: SELECT DISTINCT m.customer_merge_header_id
47: ,yt.customer_inv_line_id
48: ,m.customer_id
49: FROM dpp_customer_claims_all yt, ra_customer_merges m
50: WHERE (
51: yt.cust_account_id = m.duplicate_id
52: ) AND m.process_flag = 'N'
53: AND m.request_id = req_id

Line 184: FROM dpp_customer_claims_log yt, ra_customer_merges m

180: CURSOR merged_records IS
181: SELECT DISTINCT m.customer_merge_header_id
182: ,yt.log_id
183: ,m.customer_id
184: FROM dpp_customer_claims_log yt, ra_customer_merges m
185: WHERE (
186: yt.cust_account_id = m.duplicate_id
187: ) AND m.process_flag = 'N'
188: AND m.request_id = req_id