DBA Data[Home] [Help]

APPS.JAI_CMN_MTAX_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 430: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287

426:
427: --********* FOR SALES ORDERS
428: CURSOR c_address(p_ship_to_site_use_id IN NUMBER) IS
429: SELECT nvl(cust_acct_site_id , 0) address_id
430: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
431: WHERE A.site_use_id = p_ship_to_site_use_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
432: --WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
433:
434: CURSOR c_get_assessable_value(p_customer_id NUMBER, p_address_id NUMBER,