DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on HZ_CUST_ACCOUNTS

Line 322: FROM hz_cust_accounts c

318: CURSOR c_customer IS
319: SELECT c.tax_code,
320: NULL,
321: c.cust_account_id
322: FROM hz_cust_accounts c
323: WHERE c.cust_account_id = NVL(p_ship_to_customer_id,
324: p_bill_to_customer_id)
325: AND exists (select 1
326: from ar_vat_tax vt

Line 342: FROM hz_cust_accounts c

338: UNION
339: SELECT tg.tax_code,
340: NULL,
341: c.cust_account_id
342: FROM hz_cust_accounts c
343: ,ar_vat_tax vt
344: ,jl_zz_ar_tx_groups tg
345: ,ar_vat_tax vt1
346: WHERE c.cust_account_id = NVL(p_ship_to_customer_id,