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
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,