APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_TAXES_TL

Line 8431: -- Populating zx_taxes_tl.tax_full_name for

8427:
8428: --
8429: -- Bug 4948332
8430: --
8431: -- Populating zx_taxes_tl.tax_full_name for
8432: -- JE.CH.APXTADTC.TAX_INFO
8433: -- JE.CZ.APXTADTC.TAX_ORIGIN
8434: -- JE.HU.APXTADTC.TAX_ORIGIN
8435: -- JE.PL.APXTADTC.TAX_ORIGIN

Line 8443: INSERT INTO ZX_TAXES_TL

8439: --
8440:
8441: BEGIN
8442:
8443: INSERT INTO ZX_TAXES_TL
8444: (
8445: LANGUAGE ,
8446: SOURCE_LANG ,
8447: TAX_FULL_NAME ,

Line 8486: from ZX_TAXES_TL T

8482: AND ap_code.global_attribute_category = 'JE.CH.APXTADTC.TAX_INFO'
8483: AND flv.lookup_type = 'JECH_VAT_REGIME'
8484: AND NOT EXISTS
8485: (select NULL
8486: from ZX_TAXES_TL T
8487: where T.TAX_ID = TAXES.TAX_ID
8488: and T.LANGUAGE = FLV.LANGUAGE);
8489:
8490: --

Line 8493: INSERT INTO ZX_TAXES_TL

8489:
8490: --
8491: -- For CZ/HU/PL (Tax Origin)
8492: --
8493: INSERT INTO ZX_TAXES_TL
8494: (
8495: LANGUAGE ,
8496: SOURCE_LANG ,
8497: TAX_FULL_NAME ,

Line 8536: from ZX_TAXES_TL T

8532: AND ap_code.global_attribute_category = 'JE.CZ.APXTADTC.TAX_ORIGIN'
8533: AND flv.lookup_type = 'JGZZ_TAX_ORIGIN'
8534: AND NOT EXISTS
8535: (select NULL
8536: from ZX_TAXES_TL T
8537: where T.TAX_ID = TAXES.TAX_ID
8538: and T.LANGUAGE = FLV.LANGUAGE);
8539:
8540: INSERT INTO ZX_TAXES_TL

Line 8540: INSERT INTO ZX_TAXES_TL

8536: from ZX_TAXES_TL T
8537: where T.TAX_ID = TAXES.TAX_ID
8538: and T.LANGUAGE = FLV.LANGUAGE);
8539:
8540: INSERT INTO ZX_TAXES_TL
8541: (
8542: LANGUAGE ,
8543: SOURCE_LANG ,
8544: TAX_FULL_NAME ,

Line 8583: from ZX_TAXES_TL T

8579: AND ap_code.global_attribute_category = 'JE.HU.APXTADTC.TAX_ORIGIN'
8580: AND flv.lookup_type = 'JGZZ_TAX_ORIGIN'
8581: AND NOT EXISTS
8582: (select NULL
8583: from ZX_TAXES_TL T
8584: where T.TAX_ID = TAXES.TAX_ID
8585: and T.LANGUAGE = FLV.LANGUAGE);
8586:
8587: INSERT INTO ZX_TAXES_TL

Line 8587: INSERT INTO ZX_TAXES_TL

8583: from ZX_TAXES_TL T
8584: where T.TAX_ID = TAXES.TAX_ID
8585: and T.LANGUAGE = FLV.LANGUAGE);
8586:
8587: INSERT INTO ZX_TAXES_TL
8588: (
8589: LANGUAGE ,
8590: SOURCE_LANG ,
8591: TAX_FULL_NAME ,

Line 8630: from ZX_TAXES_TL T

8626: AND ap_code.global_attribute_category = 'JE.PL.APXTADTC.TAX_ORIGIN'
8627: AND flv.lookup_type = 'JGZZ_TAX_ORIGIN'
8628: AND NOT EXISTS
8629: (select NULL
8630: from ZX_TAXES_TL T
8631: where T.TAX_ID = TAXES.TAX_ID
8632: and T.LANGUAGE = FLV.LANGUAGE);
8633: EXCEPTION WHEN OTHERS THEN
8634: NULL;

Line 8644: INSERT INTO ZX_TAXES_TL

8640: --This fix was done in order to preserve the full tax name
8641:
8642: BEGIN
8643:
8644: INSERT INTO ZX_TAXES_TL
8645: (
8646: LANGUAGE ,
8647: SOURCE_LANG ,
8648: TAX_FULL_NAME ,

Line 8678: from ZX_TAXES_TL T

8674: L.INSTALLED_FLAG in ('I', 'B')
8675: AND RECORD_TYPE_CODE = 'MIGRATED'
8676: AND not exists
8677: (select NULL
8678: from ZX_TAXES_TL T
8679: where T.TAX_ID = B.TAX_ID
8680: and T.LANGUAGE = L.LANGUAGE_CODE);
8681: EXCEPTION WHEN OTHERS THEN
8682: NULL;