APPS.ARP_CMERGE_ARCUS dependencies on HZ_CUST_ACCOUNT_ROLES_M

Line 6852: ---------Insert into hz_cust_account_roles_m--------------

6848: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCOUNTS_M');
6849:
6850:
6851:
6852: ---------Insert into hz_cust_account_roles_m--------------
6853: --Because roles can be set up at acct and site level, we need to select
6854: --distict duplicate and customer_merge_header_id if acct with multiple sites
6855: --have roles set up at account level.
6856:

Line 6857: INSERT INTO hz_cust_account_roles_m(

6853: --Because roles can be set up at acct and site level, we need to select
6854: --distict duplicate and customer_merge_header_id if acct with multiple sites
6855: --have roles set up at account level.
6856:
6857: INSERT INTO hz_cust_account_roles_m(
6858: customer_merge_header_id,
6859: cust_account_role_id ,
6860: party_id ,
6861: cust_account_id ,

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

7006: WHERE ( ar.cust_account_id = duplicate_id OR
7007: ar.cust_acct_site_id = duplicate_address_id )
7008: AND ar.role_type = 'CONTACT';
7009:
7010: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCOUNT_ROLES_M');
7011:
7012: ---------Insert into hz_customer_profiles_m--------------
7013: --Because profiles can be set up at acct and site use level, we need to select
7014: --distict duplicate and customer_merge_header_id if acct with multiple sites