APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_STATUS_TL

Line 2717: INTO zx_status_tl

2713: l_request_id,
2714: 1
2715: )
2716: /* --Bug4400704
2717: INTO zx_status_tl
2718: (
2719: TAX_STATUS_ID,
2720: LANGUAGE,
2721: SOURCE_LANG,

Line 7305: INSERT INTO ZX_STATUS_TL

7301: --End of JATW_GOVERNMENT_TAX_TYPE lookup code
7302:
7303: arp_util_tax.debug('3:');
7304: /*
7305: INSERT INTO ZX_STATUS_TL
7306: (
7307: TAX_STATUS_ID,
7308: TAX_STATUS_NAME,
7309: CREATION_DATE,

Line 7335: from ZX_STATUS_TL T

7331: L.INSTALLED_FLAG in ('I', 'B')
7332: AND RECORD_TYPE_CODE = 'MIGRATED'
7333: AND not exists
7334: (select NULL
7335: from ZX_STATUS_TL T
7336: where T.TAX_STATUS_ID = B.TAX_STATUS_ID
7337: and T.LANGUAGE = L.LANGUAGE_CODE);*/
7338:
7339: EXCEPTION

Line 9274: | - ZX_STATUS_TL

9270: | This procedure populates data in following MLS tables :
9271: |
9272: | - ZX_REGIMES_TL
9273: | - ZX_TAXES_TL
9274: | - ZX_STATUS_TL
9275: | - ZX_RATES_TL
9276: |
9277: | It is called at the end of AR tax code migration process and
9278: | populates MLS data needed for US Tax Sales Tax migration and Tax Vendor

Line 9762: INSERT INTO ZX_STATUS_TL

9758:
9759: -- ****** STATUS ******
9760:
9761: -- Bug 4936196 : Inserting fnd_lookups.meaning for Taiwanese localization
9762: INSERT INTO ZX_STATUS_TL
9763: (
9764: TAX_STATUS_ID,
9765: TAX_STATUS_NAME,
9766: CREATION_DATE,

Line 9806: from ZX_STATUS_TL T

9802: and flv.security_group_id = 0
9803: and flv.lookup_type = 'JATW_GOVERNMENT_TAX_TYPE'
9804: and not exists
9805: (select NULL
9806: from ZX_STATUS_TL T
9807: where T.TAX_STATUS_ID = status.tax_status_id
9808: and T.LANGUAGE = flv.language);
9809:
9810: -- inserting into zx_status_tl for records other than Taiwanese localization

Line 9810: -- inserting into zx_status_tl for records other than Taiwanese localization

9806: from ZX_STATUS_TL T
9807: where T.TAX_STATUS_ID = status.tax_status_id
9808: and T.LANGUAGE = flv.language);
9809:
9810: -- inserting into zx_status_tl for records other than Taiwanese localization
9811: INSERT INTO ZX_STATUS_TL
9812: (
9813: TAX_STATUS_ID,
9814: TAX_STATUS_NAME,

Line 9811: INSERT INTO ZX_STATUS_TL

9807: where T.TAX_STATUS_ID = status.tax_status_id
9808: and T.LANGUAGE = flv.language);
9809:
9810: -- inserting into zx_status_tl for records other than Taiwanese localization
9811: INSERT INTO ZX_STATUS_TL
9812: (
9813: TAX_STATUS_ID,
9814: TAX_STATUS_NAME,
9815: CREATION_DATE,

Line 9845: from ZX_STATUS_TL T

9841: L.INSTALLED_FLAG in ('I', 'B')
9842: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9843: AND not exists
9844: (select NULL
9845: from ZX_STATUS_TL T
9846: where T.TAX_STATUS_ID = B.TAX_STATUS_ID
9847: and T.LANGUAGE = L.LANGUAGE_CODE);
9848:
9849: -- ****** RATES ******