APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_RATES_TL

Line 2791: -- zx_rates_tl is created by procedure populate_mls_tables

2787:
2788:
2789: -- ****** Inserting rates for location tax codes ******
2790:
2791: -- zx_rates_tl is created by procedure populate_mls_tables
2792: IF L_MULTI_ORG_FLAG = 'Y'
2793: THEN
2794: INSERT ALL
2795: INTO zx_rates_b_tmp

Line 5985: INSERT INTO ZX_RATES_TL

5981: --
5982: -- Create _TL tables
5983: --
5984: /*--Bug4400704
5985: INSERT INTO ZX_RATES_TL
5986: (
5987: TAX_RATE_ID,
5988: TAX_RATE_NAME,
5989: CREATED_BY,

Line 6011: FROM zx_rates_tl zrt

6007: FROM ar_vat_tax_all_tl avtt,
6008: zx_rates_b zrb
6009: WHERE avtt.vat_tax_id = zrb.tax_rate_id
6010: AND NOT EXISTS (SELECT 1
6011: FROM zx_rates_tl zrt
6012: WHERE zrt.tax_rate_id = avtt.vat_tax_id
6013: AND zrt.language = avtt.language
6014: AND zrt.source_lang = avtt.source_lang);*/
6015:

Line 9275: | - ZX_RATES_TL

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
9279: | Migration.

Line 9851: INSERT INTO ZX_RATES_TL

9847: and T.LANGUAGE = L.LANGUAGE_CODE);
9848:
9849: -- ****** RATES ******
9850:
9851: INSERT INTO ZX_RATES_TL
9852: (
9853: TAX_RATE_ID,
9854: TAX_RATE_NAME,
9855: CREATED_BY,

Line 9888: FROM zx_rates_tl t

9884: AND avtb.vat_tax_id = avtt.vat_tax_id
9885: AND b.record_type_code = 'MIGRATED'
9886: AND NOT EXISTS
9887: (SELECT 1
9888: FROM zx_rates_tl t
9889: WHERE t.tax_rate_id = b.tax_rate_id
9890: AND t.language = avtt.language);
9891:
9892:

Line 9895: INSERT INTO ZX_RATES_TL

9891:
9892:
9893: -- Code Changes for 12847663
9894:
9895: INSERT INTO ZX_RATES_TL
9896: (
9897: TAX_RATE_ID,
9898: TAX_RATE_NAME,
9899: CREATED_BY,

Line 9924: FROM zx_rates_tl zrt

9920: WHERE L.INSTALLED_FLAG in ('I', 'B')
9921: AND zrb.RECORD_TYPE_CODE = 'MIGRATED'
9922: AND zrb.tax_jurisdiction_code IS NULL
9923: AND NOT EXISTS (SELECT 1
9924: FROM zx_rates_tl zrt
9925: WHERE zrt.tax_rate_id = zrb.tax_rate_id
9926: AND zrt.language = l.language_code);
9927:
9928: EXCEPTION