APPS.ARH_ADDR_PKG dependencies on HZ_CUST_SITE_USES

Line 770: from hz_cust_site_uses

766: if ( l_status = 'A' ) then
767: --
768: select site_use_id
769: into l_site_use_id
770: from hz_cust_site_uses
771: where cust_acct_site_id = p_address_id
772: and site_use_code = 'BILL_TO'
773: and status = 'A';
774:

Line 2028: from hz_cust_site_uses

2024: check_value varchar2(1);
2025: --
2026: cursor ship_to_site is
2027: select site_use_id
2028: from hz_cust_site_uses
2029: where cust_acct_site_id = p_address_id
2030: and site_use_code = 'SHIP_TO';
2031: --
2032: cursor bill_to_site is

Line 2034: from hz_cust_site_uses

2030: and site_use_code = 'SHIP_TO';
2031: --
2032: cursor bill_to_site is
2033: select site_use_id
2034: from hz_cust_site_uses
2035: where cust_acct_site_id = p_address_id
2036: and site_use_code = 'BILL_TO';
2037: BEGIN
2038:

Line 2179: from hz_cust_site_uses_all

2175: --
2176: --{BUG#4037614 the tables accessed need to be all on site uses
2177: cursor ship_to_site is
2178: select site_use_id
2179: from hz_cust_site_uses_all
2180: where cust_acct_site_id = p_address_id
2181: and site_use_code = 'SHIP_TO';
2182: --
2183: cursor bill_to_site is

Line 2185: from hz_cust_site_uses_all

2181: and site_use_code = 'SHIP_TO';
2182: --
2183: cursor bill_to_site is
2184: select site_use_id
2185: from hz_cust_site_uses_all
2186: where cust_acct_site_id = p_address_id
2187: and site_use_code = 'BILL_TO';
2188: BEGIN
2189: