435:
436: SELECT 'valid_tax_code' into pur_dummy
437: FROM dual
438: WHERE EXISTS( SELECT NULL
439: FROM zx_input_classifications_v
440: WHERE tax_type not in ('AWT','OFFSET')
441: AND enabled_flag = 'Y'
442: AND sysdate between start_date_active and nvl(end_date_active,sysdate)
443: AND lookup_code = cr.purchasing_tax_code