APPS.HZ_CUST_ACCOUNT_SITE_V2PUB dependencies on HZ_CUST_PROFILE_AMTS

Line 1361: Updating tables hz_customer_profiles and hz_cust_profile_amts if bill-to business

1357: p_msg_level=>fnd_log.level_procedure);
1358: END IF;
1359:
1360: /*Bug 8970479 :
1361: Updating tables hz_customer_profiles and hz_cust_profile_amts if bill-to business
1362: purpose is created and if these 2 tables contains site_use_id of 'DUNNING' or 'STATEMENTS'
1363: business purposes for current site*/
1364:
1365: IF (p_cust_site_use_rec.site_use_code = 'BILL_TO') THEN

Line 1376: UPDATE hz_cust_profile_amts

1372: UPDATE hz_customer_profiles
1373: SET site_use_id = p_cust_site_use_rec.site_use_id
1374: WHERE cust_account_profile_id = l_cust_account_profile_id ;
1375:
1376: UPDATE hz_cust_profile_amts
1377: SET site_use_id = p_cust_site_use_rec.site_use_id
1378: WHERE cust_account_profile_id = l_cust_account_profile_id ;
1379:
1380: -- Debug info.