165: BEGIN
166: SELECT ctt.global_attribute4
167: INTO l_tax_code
168: FROM ra_cust_trx_types_all ctt, 169: ar_vat_tax_all vt 170: WHERE ctt.cust_trx_type_id = p_trx_type_id
171: AND ctt.org_id = vt.org_id
172: AND ctt.org_id = l_org_id
173: AND ctt.global_attribute4 = vt.tax_code