APPS.ARP_CMERGE_ARCUS dependencies on HZ_CUSTOMER_PROFILES_M

Line 7012: ---------Insert into hz_customer_profiles_m--------------

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
7015: --have profiles set up at account level.
7016:

Line 7017: 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
7015: --have profiles set up at account level.
7016:
7017: INSERT INTO hz_customer_profiles_m(
7018: customer_merge_header_id,
7019: cust_account_profile_id,
7020: last_updated_by ,
7021: last_update_date ,

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

7241: and cm.duplicate_id <> cm.customer_id ), hz_customer_profiles cp
7242: WHERE ( cp.cust_account_id = duplicate_id AND cp.site_use_id is NULL)
7243: OR (cp.site_use_id = duplicate_site_id );
7244:
7245: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUSTOMER_PROFILES_M');
7246:
7247: ---------Insert into hz_cust_profile_amts_m--------------
7248: --Because profiles can be set up at acct and site use level, we need to select
7249: --distict duplicate and customer_merge_header_id if acct with multiple sites