3558: AND tax_jurisdiction_name IS NOT NULL
3559: AND NOT EXISTS
3560: (
3561: SELECT 1
3562: FROM zx_jurisdictions_vl
3563: WHERE tax_regime_code = reg_int.tax_regime_code
3564: AND tax = reg_int.tax_code
3565: AND tax_jurisdiction_name = reg_int.tax_jurisdiction_name
3566: AND NVL(allow_tax_registrations_flag,'N') = 'Y'
3582: -- value to id conversion for tax_jurisdiction_code
3583: UPDATE zx_registrations_int reg_int
3584: SET tax_jurisdiction_code = (
3585: SELECT tax_jurisdiction_code
3586: FROM zx_jurisdictions_vl
3587: WHERE tax_regime_code = reg_int.tax_regime_code
3588: AND tax = reg_int.tax_code
3589: AND tax_jurisdiction_name = reg_int.tax_jurisdiction_name
3590: AND NVL(allow_tax_registrations_flag,'N') = 'Y'
4738: AND tax_jurisdiction_name IS NOT NULL
4739: AND NOT EXISTS
4740: (
4741: SELECT 1
4742: FROM zx_jurisdictions_vl
4743: WHERE tax_regime_code = exe_int.tax_regime_code
4744: AND tax = exe_int.tax_code
4745: AND tax_jurisdiction_name = exe_int.tax_jurisdiction_name
4746: )
4761: -- value to id conversion for tax_jurisdictin_code
4762: UPDATE zx_exemptions_int exe_int
4763: SET tax_jurisdiction_id = (
4764: SELECT tax_jurisdiction_id
4765: FROM ZX_JURISDICTIONS_VL
4766: WHERE TAX_REGIME_CODE = exe_int.tax_regime_code
4767: AND tax = exe_int.tax_code
4768: AND tax_jurisdiction_name = exe_int.tax_jurisdiction_name
4769: )