APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_STATUS_TL

Line 6607: INSERT INTO ZX_STATUS_TL

6603:
6604:
6605: -- Bug # 3907038
6606: BEGIN
6607: INSERT INTO ZX_STATUS_TL
6608: (
6609: TAX_STATUS_ID,
6610: TAX_STATUS_NAME,
6611: CREATION_DATE,

Line 6653: from ZX_STATUS_TL T

6649: AND Status.TAX_STATUS_CODE = lookups.lookup_code
6650: AND lookups.lookup_type = 'JATW_GOVERNMENT_TAX_TYPE'
6651: AND not exists
6652: (select NULL
6653: from ZX_STATUS_TL T
6654: where T.TAX_STATUS_ID = Status.TAX_STATUS_ID
6655: and T.LANGUAGE = L.LANGUAGE_CODE);
6656: EXCEPTION WHEN OTHERS THEN
6657: NULL;

Line 6671: INSERT INTO ZX_STATUS_TL

6667:
6668:
6669: BEGIN
6670:
6671: INSERT INTO ZX_STATUS_TL
6672: (
6673: TAX_STATUS_ID,
6674: TAX_STATUS_NAME,
6675: CREATION_DATE,

Line 6705: from ZX_STATUS_TL T

6701: L.INSTALLED_FLAG in ('I', 'B')
6702: AND RECORD_TYPE_CODE = 'MIGRATED'
6703: AND not exists
6704: (select NULL
6705: from ZX_STATUS_TL T
6706: where T.TAX_STATUS_ID = B.TAX_STATUS_ID
6707: and T.LANGUAGE = L.LANGUAGE_CODE);
6708: EXCEPTION WHEN OTHERS THEN
6709: NULL;