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