APPS.ARP_CMERGE_ARCUS dependencies on HZ_CUST_PROFILE_AMTS

Line 4973: FROM hz_cust_profile_amts

4969: min_interest_charge,
4970: penalty_fixed_amount,
4971: penalty_schedule_id
4972:
4973: FROM hz_cust_profile_amts
4974: WHERE cust_account_id = l_duplicate_id
4975: AND site_use_id = l_duplicate_site_id
4976: AND cust_account_profile_id = l_cust_account_profile_id;
4977:

Line 7247: ---------Insert into hz_cust_profile_amts_m--------------

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

Line 7252: 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
7250: --have profiles set up at account level.
7251:
7252: INSERT INTO hz_cust_profile_amts_m(
7253: customer_merge_header_id,
7254: cust_acct_profile_amt_id ,
7255: last_updated_by ,
7256: last_update_date ,

Line 7427: and cm.set_number = set_num ),hz_cust_profile_amts pa

7423: FROM (select distinct duplicate_id,duplicate_site_id,customer_merge_header_id
7424: from ra_customer_merges cm
7425: where cm.process_flag = 'N'
7426: and cm.request_id = req_id
7427: and cm.set_number = set_num ),hz_cust_profile_amts pa
7428: WHERE (pa.cust_account_id = duplicate_id and pa.site_use_id is NULL)
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');

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

7427: and cm.set_number = set_num ),hz_cust_profile_amts pa
7428: WHERE (pa.cust_account_id = duplicate_id and pa.site_use_id is NULL)
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,