APPS.ARP_CMERGE_ARCUS dependencies on HZ_CUST_ACCOUNT_ROLES_M

Line 7203: ---------Insert into hz_cust_account_roles_m--------------

7199: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCOUNTS_M');
7200:
7201:
7202:
7203: ---------Insert into hz_cust_account_roles_m--------------
7204: --Because roles can be set up at acct and site level, we need to select
7205: --distict duplicate and customer_merge_header_id if acct with multiple sites
7206: --have roles set up at account level.
7207:

Line 7208: INSERT INTO hz_cust_account_roles_m(

7204: --Because roles can be set up at acct and site level, we need to select
7205: --distict duplicate and customer_merge_header_id if acct with multiple sites
7206: --have roles set up at account level.
7207:
7208: INSERT INTO hz_cust_account_roles_m(
7209: customer_merge_header_id,
7210: cust_account_role_id ,
7211: party_id ,
7212: cust_account_id ,

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

7357: WHERE ( ar.cust_account_id = duplicate_id OR
7358: ar.cust_acct_site_id = duplicate_address_id )
7359: AND ar.role_type = 'CONTACT';
7360:
7361: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCOUNT_ROLES_M');
7362:
7363: ---------Insert into hz_customer_profiles_m--------------
7364: --Because profiles can be set up at acct and site use level, we need to select
7365: --distict duplicate and customer_merge_header_id if acct with multiple sites