APPS.ARP_ADDR_PKG dependencies on HZ_CUST_ACCT_SITES

Line 339: update hz_cust_acct_sites

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

Line 391: from hz_cust_acct_sites addr

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