APPS.ARP_CMERGE_ARCUS dependencies on HZ_CUSTOMER_PROFILES

Line 6221: FROM hz_customer_profiles

6217: cust_prof_rec.multiple_interest_rates_flag,
6218: cust_prof_rec.charge_begin_date,
6219: cust_prof_rec.automatch_set_id --8477178
6220:
6221: FROM hz_customer_profiles
6222: WHERE cust_account_id = l_duplicate_id
6223: AND site_use_id = l_duplicate_site_id
6224: AND ROWNUM = 1; -- in case of data problem: one site use has 2 profiles.
6225:

Line 6633: FROM hz_customer_profiles

6629:
6630: arp_message.set_line('create_same_sites:create_profile_amount');
6631:
6632: SELECT cust_account_profile_id INTO l_to_cust_account_profile_id
6633: FROM hz_customer_profiles
6634: WHERE cust_account_id = l_customer_id
6635: AND site_use_id = l_customer_site_id;
6636:
6637: -- Create Customer Profile Amts for customer id

Line 7363: ---------Insert into hz_customer_profiles_m--------------

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

Line 7368: 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
7366: --have profiles set up at account level.
7367:
7368: INSERT INTO hz_customer_profiles_m(
7369: customer_merge_header_id,
7370: cust_account_profile_id,
7371: last_updated_by ,
7372: last_update_date ,

Line 7594: and cm.duplicate_id <> cm.customer_id ), hz_customer_profiles cp

7590: from ra_customer_merges cm
7591: where cm.process_flag = 'N'
7592: and cm.request_id = req_id
7593: and cm.set_number = set_num
7594: and cm.duplicate_id <> cm.customer_id ), hz_customer_profiles cp
7595: WHERE ( cp.cust_account_id = duplicate_id AND cp.site_use_id is NULL)
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');

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

7594: and cm.duplicate_id <> cm.customer_id ), hz_customer_profiles cp
7595: WHERE ( cp.cust_account_id = duplicate_id AND cp.site_use_id is NULL)
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