DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_STATUS_TL

Line 6638: INSERT INTO ZX_STATUS_TL

6634:
6635:
6636: -- Bug # 3907038
6637: BEGIN
6638: INSERT INTO ZX_STATUS_TL
6639: (
6640: TAX_STATUS_ID,
6641: TAX_STATUS_NAME,
6642: CREATION_DATE,

Line 6684: from ZX_STATUS_TL T

6680: AND Status.TAX_STATUS_CODE = lookups.lookup_code
6681: AND lookups.lookup_type = 'JATW_GOVERNMENT_TAX_TYPE'
6682: AND not exists
6683: (select NULL
6684: from ZX_STATUS_TL T
6685: where T.TAX_STATUS_ID = Status.TAX_STATUS_ID
6686: and T.LANGUAGE = L.LANGUAGE_CODE);
6687: EXCEPTION WHEN OTHERS THEN
6688: NULL;

Line 6702: INSERT INTO ZX_STATUS_TL

6698:
6699:
6700: BEGIN
6701:
6702: INSERT INTO ZX_STATUS_TL
6703: (
6704: TAX_STATUS_ID,
6705: TAX_STATUS_NAME,
6706: CREATION_DATE,

Line 6736: from ZX_STATUS_TL T

6732: L.INSTALLED_FLAG in ('I', 'B')
6733: AND RECORD_TYPE_CODE = 'MIGRATED'
6734: AND not exists
6735: (select NULL
6736: from ZX_STATUS_TL T
6737: where T.TAX_STATUS_ID = B.TAX_STATUS_ID
6738: and T.LANGUAGE = L.LANGUAGE_CODE);
6739: EXCEPTION WHEN OTHERS THEN
6740: NULL;