APPS.ARP_CMERGE_MASTER dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2353: from hz_cust_acct_sites_ALL site,ra_customer_merges m --SSUptake

2349: program_id = hz_utility_v2pub.program_id,
2350: program_update_date = sysdate
2351: WHERE EXISTS
2352: ( select 'Y'
2353: from hz_cust_acct_sites_ALL site,ra_customer_merges m --SSUptake
2354: where site.cust_account_id = from_customer_id
2355: and m.duplicate_address_id = site.cust_acct_site_id
2356: and su.cust_acct_site_id = site.cust_acct_site_id
2357: and m.request_id = req_id

Line 2371: UPDATE HZ_CUST_ACCT_SITES_ALL addr --SSUptake

2367: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_SITE_USES');
2368:
2369:
2370: /*--Unset the status to 'I'for HZ_CUST_ACCT_SITES which was set to 'D' --*/
2371: UPDATE HZ_CUST_ACCT_SITES_ALL addr --SSUptake
2372: set status = 'I',
2373: last_update_date = sysdate,
2374: last_updated_by = hz_utility_v2pub.user_id,
2375: last_update_login = hz_utility_v2pub.last_update_login,