APPS.HZ_ACCT_MERGE_UTIL dependencies on RA_CUSTOMER_MERGES

Line 28: FROM ra_customer_merges

24: g_site_list.DELETE;
25: g_addr_list.DELETE;
26: FOR CUST IN (
27: SELECT distinct customer_id, duplicate_id
28: FROM ra_customer_merges
29: WHERE set_number = p_set_num
30: AND request_id = p_request_id
31: AND process_flag = 'N' ) LOOP
32: g_cust_list(CUST.duplicate_id) := CUST.customer_id;

Line 36: FROM ra_customer_merges

32: g_cust_list(CUST.duplicate_id) := CUST.customer_id;
33: END LOOP;
34: FOR ADDR IN (
35: SELECT distinct customer_address_id, duplicate_address_id
36: FROM ra_customer_merges
37: WHERE set_number = p_set_num
38: AND request_id = p_request_id
39: AND process_flag = 'N' ) LOOP
40: g_addr_list(ADDR.duplicate_address_id) := ADDR.customer_address_id;

Line 45: FROM ra_customer_merges

41: END LOOP;
42:
43: FOR SITE IN (
44: SELECT distinct customer_site_id, duplicate_site_id
45: FROM ra_customer_merges
46: WHERE set_number = p_set_num
47: AND request_id = p_request_id
48: AND process_flag = 'N' ) LOOP
49: g_site_list(SITE.duplicate_site_id) := SITE.customer_site_id;