APPS.ARP_CMERGE_ARCUS dependencies on HZ_CUST_ACCT_SITES_ALL_M

Line 7433: ---------Insert into hz_cust_acct_sites_all_m--------------

7429: OR (pa.site_use_id = duplicate_site_id);
7430:
7431: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_PROFILE_AMTS_M');
7432:
7433: ---------Insert into hz_cust_acct_sites_all_m--------------
7434: INSERT INTO hz_cust_acct_sites_all_m(
7435: customer_merge_header_id,
7436: cust_acct_site_id ,
7437: cust_account_id ,

Line 7434: INSERT INTO hz_cust_acct_sites_all_m(

7430:
7431: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_PROFILE_AMTS_M');
7432:
7433: ---------Insert into hz_cust_acct_sites_all_m--------------
7434: INSERT INTO hz_cust_acct_sites_all_m(
7435: customer_merge_header_id,
7436: cust_acct_site_id ,
7437: cust_account_id ,
7438: party_site_id ,

Line 7601: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCT_SITES_ALL_M');

7597: and cm.set_number = set_num ) m,hz_cust_acct_sites_all acs
7598: WHERE acs.cust_acct_site_id = duplicate_address_id
7599: AND acs.org_id = m.org_id ;
7600:
7601: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCT_SITES_ALL_M');
7602:
7603: ---------Insert into hz_cust_site_uses_all_m--------------
7604: INSERT INTO hz_cust_site_uses_all_m(
7605: customer_merge_header_id,