APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_TAXES_TL

Line 8453: -- Populating zx_taxes_tl.tax_full_name for

8449:
8450: --
8451: -- Bug 4948332
8452: --
8453: -- Populating zx_taxes_tl.tax_full_name for
8454: -- JE.CH.APXTADTC.TAX_INFO
8455: -- JE.CZ.APXTADTC.TAX_ORIGIN
8456: -- JE.HU.APXTADTC.TAX_ORIGIN
8457: -- JE.PL.APXTADTC.TAX_ORIGIN

Line 8465: INSERT INTO ZX_TAXES_TL

8461: --
8462:
8463: BEGIN
8464:
8465: INSERT INTO ZX_TAXES_TL
8466: (
8467: LANGUAGE ,
8468: SOURCE_LANG ,
8469: TAX_FULL_NAME ,

Line 8508: from ZX_TAXES_TL T

8504: AND ap_code.global_attribute_category = 'JE.CH.APXTADTC.TAX_INFO'
8505: AND flv.lookup_type = 'JECH_VAT_REGIME'
8506: AND NOT EXISTS
8507: (select NULL
8508: from ZX_TAXES_TL T
8509: where T.TAX_ID = TAXES.TAX_ID
8510: and T.LANGUAGE = FLV.LANGUAGE);
8511:
8512: --

Line 8515: INSERT INTO ZX_TAXES_TL

8511:
8512: --
8513: -- For CZ/HU/PL (Tax Origin)
8514: --
8515: INSERT INTO ZX_TAXES_TL
8516: (
8517: LANGUAGE ,
8518: SOURCE_LANG ,
8519: TAX_FULL_NAME ,

Line 8558: from ZX_TAXES_TL T

8554: AND ap_code.global_attribute_category = 'JE.CZ.APXTADTC.TAX_ORIGIN'
8555: AND flv.lookup_type = 'JGZZ_TAX_ORIGIN'
8556: AND NOT EXISTS
8557: (select NULL
8558: from ZX_TAXES_TL T
8559: where T.TAX_ID = TAXES.TAX_ID
8560: and T.LANGUAGE = FLV.LANGUAGE);
8561:
8562: INSERT INTO ZX_TAXES_TL

Line 8562: INSERT INTO ZX_TAXES_TL

8558: from ZX_TAXES_TL T
8559: where T.TAX_ID = TAXES.TAX_ID
8560: and T.LANGUAGE = FLV.LANGUAGE);
8561:
8562: INSERT INTO ZX_TAXES_TL
8563: (
8564: LANGUAGE ,
8565: SOURCE_LANG ,
8566: TAX_FULL_NAME ,

Line 8605: from ZX_TAXES_TL T

8601: AND ap_code.global_attribute_category = 'JE.HU.APXTADTC.TAX_ORIGIN'
8602: AND flv.lookup_type = 'JGZZ_TAX_ORIGIN'
8603: AND NOT EXISTS
8604: (select NULL
8605: from ZX_TAXES_TL T
8606: where T.TAX_ID = TAXES.TAX_ID
8607: and T.LANGUAGE = FLV.LANGUAGE);
8608:
8609: INSERT INTO ZX_TAXES_TL

Line 8609: INSERT INTO ZX_TAXES_TL

8605: from ZX_TAXES_TL T
8606: where T.TAX_ID = TAXES.TAX_ID
8607: and T.LANGUAGE = FLV.LANGUAGE);
8608:
8609: INSERT INTO ZX_TAXES_TL
8610: (
8611: LANGUAGE ,
8612: SOURCE_LANG ,
8613: TAX_FULL_NAME ,

Line 8652: from ZX_TAXES_TL T

8648: AND ap_code.global_attribute_category = 'JE.PL.APXTADTC.TAX_ORIGIN'
8649: AND flv.lookup_type = 'JGZZ_TAX_ORIGIN'
8650: AND NOT EXISTS
8651: (select NULL
8652: from ZX_TAXES_TL T
8653: where T.TAX_ID = TAXES.TAX_ID
8654: and T.LANGUAGE = FLV.LANGUAGE);
8655: EXCEPTION WHEN OTHERS THEN
8656: NULL;

Line 8666: INSERT INTO ZX_TAXES_TL

8662: --This fix was done in order to preserve the full tax name
8663:
8664: BEGIN
8665:
8666: INSERT INTO ZX_TAXES_TL
8667: (
8668: LANGUAGE ,
8669: SOURCE_LANG ,
8670: TAX_FULL_NAME ,

Line 8700: from ZX_TAXES_TL T

8696: L.INSTALLED_FLAG in ('I', 'B')
8697: AND RECORD_TYPE_CODE = 'MIGRATED'
8698: AND not exists
8699: (select NULL
8700: from ZX_TAXES_TL T
8701: where T.TAX_ID = B.TAX_ID
8702: and T.LANGUAGE = L.LANGUAGE_CODE);
8703: EXCEPTION WHEN OTHERS THEN
8704: NULL;