4522: AND tax_name IS NOT NULL
4523: AND NOT EXISTS
4524: (
4525: SELECT 1
4526: FROM zx_taxes_vl ztvl,
4527: zx_subscription_details sd
4528: WHERE ztvl.tax_regime_code = sd.tax_regime_code
4529: AND ztvl.content_owner_id = sd.parent_first_pty_org_id
4530: AND (sd.view_options_code in ('NONE', 'VFC')
4559: -- value to id conversion for tax
4560: UPDATE zx_exemptions_int exe_int
4561: SET tax_code = (
4562: SELECT ztvl.tax
4563: FROM zx_taxes_vl ztvl,
4564: zx_subscription_details sd
4565: WHERE ztvl.tax_regime_code = sd.tax_regime_code
4566: AND ztvl.content_owner_id = sd.parent_first_pty_org_id
4567: AND (sd.view_options_code in ('NONE', 'VFC')