APPS.ZX_VTX_USER_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 1825: FROM HZ_CUST_SITE_USES_ALL cust_site_uses

1821: IF ship_to_site_use_tab(i) is NOT NULL THEN
1822: BEGIN
1823: SELECT cust_site_uses.cust_acct_site_id
1824: INTO ship_to_address_id_tab(i)
1825: FROM HZ_CUST_SITE_USES_ALL cust_site_uses
1826: WHERE cust_site_uses.site_use_id = ship_to_site_use_tab(i);
1827: EXCEPTION WHEN OTHERS THEN
1828: ship_to_address_id_tab(i) := NULL;
1829: END;

Line 1836: FROM HZ_CUST_SITE_USES_ALL

1832: IF ship_to_address_id_tab(i) is NULL THEN
1833: BEGIN
1834: SELECT cust_acct_site_id
1835: INTO ship_to_address_id_tab(i)
1836: FROM HZ_CUST_SITE_USES_ALL
1837: WHERE site_use_id = bill_to_site_use_tab(i);
1838: EXCEPTION WHEN NO_DATA_FOUND THEN
1839: ship_to_address_id_tab(i) := NULL;
1840: END;