APPS.ZX_VTX_USER_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 1679: FROM HZ_CUST_SITE_USES_ALL cust_site_uses

1675: IF ship_to_site_use_tab(i) is NOT NULL THEN
1676: BEGIN
1677: SELECT cust_site_uses.cust_acct_site_id
1678: INTO ship_to_address_id_tab(i)
1679: FROM HZ_CUST_SITE_USES_ALL cust_site_uses
1680: WHERE cust_site_uses.site_use_id = ship_to_site_use_tab(i);
1681: EXCEPTION WHEN OTHERS THEN
1682: ship_to_address_id_tab(i) := NULL;
1683: END;

Line 1690: FROM HZ_CUST_SITE_USES_ALL

1686: IF ship_to_address_id_tab(i) is NULL THEN
1687: BEGIN
1688: SELECT cust_acct_site_id
1689: INTO ship_to_address_id_tab(i)
1690: FROM HZ_CUST_SITE_USES_ALL
1691: WHERE site_use_id = bill_to_site_use_tab(i);
1692: EXCEPTION WHEN NO_DATA_FOUND THEN
1693: ship_to_address_id_tab(i) := NULL;
1694: END;