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 343: FROM hz_cust_accounts c

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