DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on ZX_JURISDICTIONS_VL

Line 3562: FROM zx_jurisdictions_vl

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'

Line 3586: FROM zx_jurisdictions_vl

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'

Line 4742: FROM zx_jurisdictions_vl

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: )

Line 4765: FROM ZX_JURISDICTIONS_VL

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: )