APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_REGIMES_TL

Line 408: l_tax_regime_name zx_regimes_tl.tax_regime_name%TYPE; --VARCHAR2(30)

404: l_temp_seg_name VARCHAR2(30); --Bug 4204464
405: l_temp_appl_col_name VARCHAR2(30);
406:
407: l_min_start_date DATE;
408: l_tax_regime_name zx_regimes_tl.tax_regime_name%TYPE; --VARCHAR2(30)
409: l_tax_regime_code zx_regimes_b.tax_regime_code%TYPE; --VARCHAR2(80)
410: l_count PLS_INTEGER; --Bug 4204464
411: l_tax_acct_cr_method VARCHAR2(30);
412: l_tax_acct_source_tax VARCHAR2(30);

Line 1265: INTO ZX_REGIMES_TL

1261: FROM ZX_REGIMES_B
1262: WHERE TAX_REGIME_CODE = l_tax_regime_code
1263: )
1264: ) THEN
1265: INTO ZX_REGIMES_TL
1266: (
1267: LANGUAGE ,
1268: SOURCE_LANG ,
1269: TAX_REGIME_NAME ,

Line 8393: INSERT INTO ZX_REGIMES_TL

8389: );
8390:
8391:
8392: -- Populate _TL table
8393: INSERT INTO ZX_REGIMES_TL
8394: (
8395: LANGUAGE ,
8396: SOURCE_LANG ,
8397: TAX_REGIME_NAME ,

Line 8450: from ZX_REGIMES_TL T

8446: AND b.tax_regime_code = d.tax_regime_code (+)
8447:
8448: AND not exists
8449: (select NULL
8450: from ZX_REGIMES_TL T
8451: where T.TAX_REGIME_ID = B.TAX_REGIME_ID
8452: and T.LANGUAGE = L.LANGUAGE_CODE);
8453: EXCEPTION
8454: WHEN OTHERS THEN

Line 9260: | - ZX_REGIMES_TL

9256: |
9257: | DESCRIPTION
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: |

Line 9286: INSERT INTO ZX_REGIMES_TL

9282: PROCEDURE populate_mls_tables
9283: AS
9284: BEGIN
9285: -- ****** REGIMES ******
9286: INSERT INTO ZX_REGIMES_TL
9287: (
9288: TAX_REGIME_ID,
9289: TAX_REGIME_NAME,
9290: CREATION_DATE,

Line 9320: from ZX_REGIMES_TL T

9316: L.INSTALLED_FLAG in ('I', 'B')
9317: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9318: AND not exists
9319: (select NULL
9320: from ZX_REGIMES_TL T
9321: where T.TAX_REGIME_ID = B.TAX_REGIME_ID
9322: and T.LANGUAGE = L.LANGUAGE_CODE);
9323:
9324: -- ****** TAXES ******