APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_STATUS_TL

Line 2629: INTO zx_status_tl

2625: l_request_id,
2626: 1
2627: )
2628: /* --Bug4400704
2629: INTO zx_status_tl
2630: (
2631: TAX_STATUS_ID,
2632: LANGUAGE,
2633: SOURCE_LANG,

Line 7293: INSERT INTO ZX_STATUS_TL

7289: --End of JATW_GOVERNMENT_TAX_TYPE lookup code
7290:
7291: arp_util_tax.debug('3:');
7292: /*
7293: INSERT INTO ZX_STATUS_TL
7294: (
7295: TAX_STATUS_ID,
7296: TAX_STATUS_NAME,
7297: CREATION_DATE,

Line 7323: from ZX_STATUS_TL T

7319: L.INSTALLED_FLAG in ('I', 'B')
7320: AND RECORD_TYPE_CODE = 'MIGRATED'
7321: AND not exists
7322: (select NULL
7323: from ZX_STATUS_TL T
7324: where T.TAX_STATUS_ID = B.TAX_STATUS_ID
7325: and T.LANGUAGE = L.LANGUAGE_CODE);*/
7326:
7327: EXCEPTION

Line 9262: | - ZX_STATUS_TL

9258: | This procedure populates data in following MLS tables :
9259: |
9260: | - ZX_REGIMES_TL
9261: | - ZX_TAXES_TL
9262: | - ZX_STATUS_TL
9263: | - ZX_RATES_TL
9264: |
9265: | It is called at the end of AR tax code migration process and
9266: | populates MLS data needed for US Tax Sales Tax migration and Tax Vendor

Line 9750: INSERT INTO ZX_STATUS_TL

9746:
9747: -- ****** STATUS ******
9748:
9749: -- Bug 4936196 : Inserting fnd_lookups.meaning for Taiwanese localization
9750: INSERT INTO ZX_STATUS_TL
9751: (
9752: TAX_STATUS_ID,
9753: TAX_STATUS_NAME,
9754: CREATION_DATE,

Line 9794: from ZX_STATUS_TL T

9790: and flv.security_group_id = 0
9791: and flv.lookup_type = 'JATW_GOVERNMENT_TAX_TYPE'
9792: and not exists
9793: (select NULL
9794: from ZX_STATUS_TL T
9795: where T.TAX_STATUS_ID = status.tax_status_id
9796: and T.LANGUAGE = flv.language);
9797:
9798: -- inserting into zx_status_tl for records other than Taiwanese localization

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

9794: from ZX_STATUS_TL T
9795: where T.TAX_STATUS_ID = status.tax_status_id
9796: and T.LANGUAGE = flv.language);
9797:
9798: -- inserting into zx_status_tl for records other than Taiwanese localization
9799: INSERT INTO ZX_STATUS_TL
9800: (
9801: TAX_STATUS_ID,
9802: TAX_STATUS_NAME,

Line 9799: INSERT INTO ZX_STATUS_TL

9795: where T.TAX_STATUS_ID = status.tax_status_id
9796: and T.LANGUAGE = flv.language);
9797:
9798: -- inserting into zx_status_tl for records other than Taiwanese localization
9799: INSERT INTO ZX_STATUS_TL
9800: (
9801: TAX_STATUS_ID,
9802: TAX_STATUS_NAME,
9803: CREATION_DATE,

Line 9833: from ZX_STATUS_TL T

9829: L.INSTALLED_FLAG in ('I', 'B')
9830: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9831: AND not exists
9832: (select NULL
9833: from ZX_STATUS_TL T
9834: where T.TAX_STATUS_ID = B.TAX_STATUS_ID
9835: and T.LANGUAGE = L.LANGUAGE_CODE);
9836:
9837: -- ****** RATES ******