APPS.ZX_TAXWARE_USER_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 1751: FROM HZ_CUST_SITE_USES_ALL cust_site_uses

1747: IF ship_to_site_use_tab(i) is NOT NULL THEN
1748: BEGIN
1749: SELECT cust_site_uses.cust_acct_site_id
1750: INTO ship_to_address_id_tab(i)
1751: FROM HZ_CUST_SITE_USES_ALL cust_site_uses
1752: WHERE cust_site_uses.site_use_id = ship_to_site_use_tab(i);
1753: EXCEPTION WHEN OTHERS THEN
1754: ship_to_address_id_tab(i) := NULL;
1755: END;

Line 1762: FROM HZ_CUST_SITE_USES_ALL

1758: IF ship_to_address_id_tab(i) is NULL THEN
1759: BEGIN
1760: SELECT cust_acct_site_id
1761: INTO ship_to_address_id_tab(i)
1762: FROM HZ_CUST_SITE_USES_ALL
1763: WHERE site_use_id = bill_to_site_use_tab(i);
1764: EXCEPTION WHEN NO_DATA_FOUND THEN
1765: ship_to_address_id_tab(i) := NULL;
1766: END;