[Home] [Help]
5281: min_interest_charge,
5282: penalty_fixed_amount,
5283: penalty_schedule_id
5284:
5285: FROM hz_cust_profile_amts
5286: WHERE cust_account_id = l_duplicate_id
5287: AND site_use_id = l_duplicate_site_id
5288: AND cust_account_profile_id = l_cust_account_profile_id;
5289:
7596: OR (cp.site_use_id = duplicate_site_id );
7597:
7598: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUSTOMER_PROFILES_M');
7599:
7600: ---------Insert into hz_cust_profile_amts_m--------------
7601: --Because profiles can be set up at acct and site use level, we need to select
7602: --distict duplicate and customer_merge_header_id if acct with multiple sites
7603: --have profiles set up at account level.
7604:
7601: --Because profiles can be set up at acct and site use level, we need to select
7602: --distict duplicate and customer_merge_header_id if acct with multiple sites
7603: --have profiles set up at account level.
7604:
7605: INSERT INTO hz_cust_profile_amts_m(
7606: customer_merge_header_id,
7607: cust_acct_profile_amt_id ,
7608: last_updated_by ,
7609: last_update_date ,
7776: FROM (select distinct duplicate_id,duplicate_site_id,customer_merge_header_id
7777: from ra_customer_merges cm
7778: where cm.process_flag = 'N'
7779: and cm.request_id = req_id
7780: and cm.set_number = set_num ),hz_cust_profile_amts pa
7781: WHERE (pa.cust_account_id = duplicate_id and pa.site_use_id is NULL)
7782: OR (pa.site_use_id = duplicate_site_id);
7783:
7784: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_PROFILE_AMTS_M');
7780: and cm.set_number = set_num ),hz_cust_profile_amts pa
7781: WHERE (pa.cust_account_id = duplicate_id and pa.site_use_id is NULL)
7782: OR (pa.site_use_id = duplicate_site_id);
7783:
7784: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_PROFILE_AMTS_M');
7785:
7786: ---------Insert into hz_cust_acct_sites_all_m--------------
7787: INSERT INTO hz_cust_acct_sites_all_m(
7788: customer_merge_header_id,