APPS.IEX_TERR_PUB dependencies on HZ_CUSTOMER_PROFILES

Line 426: UPDATE HZ_CUSTOMER_PROFILES ACC

422: logmessage('Start updating the Customer Profiles Table' );
423:
424: FOR i IN x_winners_rec.terr_id.FIRST .. x_winners_rec.terr_id.LAST LOOP
425: BEGIN
426: UPDATE HZ_CUSTOMER_PROFILES ACC
427: SET object_version_number = nvl(object_version_number,0) + 1,
428: ACC.LAST_UPDATE_DATE = SYSDATE,
429: ACC.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
430: ACC.LAST_UPDATE_LOGIN = FND_GLOBAL.login_id ,

Line 539: from hz_customer_profiles where CUST_ACCOUNT_PROFILE_id = l_profile_id;

535: IF NOT isRefreshProgramsRunning THEN
536:
537: SELECT cust_account_id, site_use_id, party_id,collector_id
538: into l_custaccount_id, l_siteuse_id, l_party_id ,l_collector_id
539: from hz_customer_profiles where CUST_ACCOUNT_PROFILE_id = l_profile_id;
540:
541: logMessage ('profile_check: ' || 'l_custaccount_id =>'||l_custaccount_id);
542: logMessage ('profile_check: ' || 'l_siteuse_id =>' || l_siteuse_id);
543: logMessage ('profile_check: ' || 'l_collector_id =>' || l_collector_id);