APPS.ZX_TAXWARE_USER_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 1903: FROM HZ_CUST_SITE_USES_ALL cust_site_uses

1899: IF ship_to_site_use_tab(i) is NOT NULL THEN
1900: BEGIN
1901: SELECT cust_site_uses.cust_acct_site_id
1902: INTO ship_to_address_id_tab(i)
1903: FROM HZ_CUST_SITE_USES_ALL cust_site_uses
1904: WHERE cust_site_uses.site_use_id = ship_to_site_use_tab(i);
1905: EXCEPTION WHEN OTHERS THEN
1906: ship_to_address_id_tab(i) := NULL;
1907: END;

Line 1914: FROM HZ_CUST_SITE_USES_ALL

1910: IF ship_to_address_id_tab(i) is NULL THEN
1911: BEGIN
1912: SELECT cust_acct_site_id
1913: INTO ship_to_address_id_tab(i)
1914: FROM HZ_CUST_SITE_USES_ALL
1915: WHERE site_use_id = bill_to_site_use_tab(i);
1916: EXCEPTION WHEN NO_DATA_FOUND THEN
1917: ship_to_address_id_tab(i) := NULL;
1918: END;