APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_RATES_TL

Line 2703: -- zx_rates_tl is created by procedure populate_mls_tables

2699:
2700:
2701: -- ****** Inserting rates for location tax codes ******
2702:
2703: -- zx_rates_tl is created by procedure populate_mls_tables
2704: IF L_MULTI_ORG_FLAG = 'Y'
2705: THEN
2706: INSERT ALL
2707: INTO zx_rates_b_tmp

Line 5973: INSERT INTO ZX_RATES_TL

5969: --
5970: -- Create _TL tables
5971: --
5972: /*--Bug4400704
5973: INSERT INTO ZX_RATES_TL
5974: (
5975: TAX_RATE_ID,
5976: TAX_RATE_NAME,
5977: CREATED_BY,

Line 5999: FROM zx_rates_tl zrt

5995: FROM ar_vat_tax_all_tl avtt,
5996: zx_rates_b zrb
5997: WHERE avtt.vat_tax_id = zrb.tax_rate_id
5998: AND NOT EXISTS (SELECT 1
5999: FROM zx_rates_tl zrt
6000: WHERE zrt.tax_rate_id = avtt.vat_tax_id
6001: AND zrt.language = avtt.language
6002: AND zrt.source_lang = avtt.source_lang);*/
6003:

Line 9263: | - ZX_RATES_TL

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

Line 9838: INSERT INTO ZX_RATES_TL

9834: where T.TAX_STATUS_ID = B.TAX_STATUS_ID
9835: and T.LANGUAGE = L.LANGUAGE_CODE);
9836:
9837: -- ****** RATES ******
9838: INSERT INTO ZX_RATES_TL
9839: (
9840: TAX_RATE_ID,
9841: TAX_RATE_NAME,
9842: CREATED_BY,

Line 9872: FROM zx_rates_tl zrt

9868: zx_rates_b zrb
9869: WHERE avtt.vat_tax_id = zrb.tax_rate_id
9870: AND avtt.vat_tax_id = avtb.vat_tax_id
9871: AND NOT EXISTS (SELECT 1
9872: FROM zx_rates_tl zrt
9873: WHERE zrt.tax_rate_id = avtt.vat_tax_id
9874: AND zrt.language = avtt.language);
9875: EXCEPTION
9876: WHEN OTHERS THEN

Line 10158: INSERT INTO ZX_RATES_TL

10154: )
10155: SELECT 1 FROM DUAL;
10156:
10157: -- *** Note *** Need to insert into _tl as we're creating new records
10158: INSERT INTO ZX_RATES_TL
10159: (
10160: TAX_RATE_ID,
10161: TAX_RATE_NAME,
10162: CREATED_BY,

Line 10197: FROM zx_rates_tl t

10193: AND ptp.party_id = asp.org_id
10194: AND ptp.party_type_code = 'OU'
10195: AND NOT EXISTS
10196: (SELECT 1
10197: FROM zx_rates_tl t
10198: WHERE t.tax_rate_id = b.tax_rate_id
10199: AND t.language = l.language_code);
10200:
10201: EXCEPTION