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 1351: INTO ZX_REGIMES_TL

1347: FROM ZX_REGIMES_B
1348: WHERE TAX_REGIME_CODE = l_tax_regime_code
1349: )
1350: ) THEN
1351: INTO ZX_REGIMES_TL
1352: (
1353: LANGUAGE ,
1354: SOURCE_LANG ,
1355: TAX_REGIME_NAME ,

Line 8405: INSERT INTO ZX_REGIMES_TL

8401: );
8402:
8403:
8404: -- Populate _TL table
8405: INSERT INTO ZX_REGIMES_TL
8406: (
8407: LANGUAGE ,
8408: SOURCE_LANG ,
8409: TAX_REGIME_NAME ,

Line 8462: from ZX_REGIMES_TL T

8458: AND b.tax_regime_code = d.tax_regime_code (+)
8459:
8460: AND not exists
8461: (select NULL
8462: from ZX_REGIMES_TL T
8463: where T.TAX_REGIME_ID = B.TAX_REGIME_ID
8464: and T.LANGUAGE = L.LANGUAGE_CODE);
8465: EXCEPTION
8466: WHEN OTHERS THEN

Line 9272: | - ZX_REGIMES_TL

9268: |
9269: | DESCRIPTION
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: |

Line 9298: INSERT INTO ZX_REGIMES_TL

9294: PROCEDURE populate_mls_tables
9295: AS
9296: BEGIN
9297: -- ****** REGIMES ******
9298: INSERT INTO ZX_REGIMES_TL
9299: (
9300: TAX_REGIME_ID,
9301: TAX_REGIME_NAME,
9302: CREATION_DATE,

Line 9332: from ZX_REGIMES_TL T

9328: L.INSTALLED_FLAG in ('I', 'B')
9329: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9330: AND not exists
9331: (select NULL
9332: from ZX_REGIMES_TL T
9333: where T.TAX_REGIME_ID = B.TAX_REGIME_ID
9334: and T.LANGUAGE = L.LANGUAGE_CODE);
9335:
9336: -- ****** TAXES ******