APPS.JAI_OM_TAX_PKG dependencies on HZ_CUST_SITE_USES_ALL

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

3456: v_order_source_type varchar2(240);
3457:
3458: CURSOR address_cur(p_ship_to_site_use_id IN Number) IS
3459: SELECT nvl(cust_acct_site_id , 0) address_id
3460: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
3461: WHERE A.site_use_id = p_ship_to_site_use_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3462: --WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
3463:
3464: /* Bug 5243532. Added by Lakshmi Gopalsami