APPS.ARP_ADDR_PKG dependencies on HZ_CUST_ACCT_SITES

Line 338: update hz_cust_acct_sites

334: --
335: -- The procedure is only callled if one of the flags requires updating
336: -- therfore the if then else logic has been pushed into the sql
337: --
338: update hz_cust_acct_sites
339: set bill_to_flag = decode(p_site_use_code,
340: 'BILL_TO',p_site_use_flag,
341: bill_to_flag),
342: ship_to_flag = decode(p_site_use_code,

Line 390: from hz_cust_acct_sites addr

386: --
387: begin
388: select count(1)
389: into dummy
390: from hz_cust_acct_sites addr
391: where addr.orig_system_reference = p_orig_system_reference;
392: --
393: --
394: if ( dummy >=1 ) then