APPS.ZX_TAX_CONTENT_UPLOAD dependencies on ZX_RATES_TL

Line 5655: FROM ZX_RATES_TL zrt

5651: AND zrb.TAX IN ('STATE','COUNTY','CITY')
5652: AND zrb.CONTENT_OWNER_ID = -99
5653: AND zrb.RECORD_TYPE_CODE = G_CREATED_BY_MODULE
5654: AND NOT EXISTS (SELECT NULL
5655: FROM ZX_RATES_TL zrt
5656: WHERE zrt.TAX_RATE_ID = zrb.TAX_RATE_ID)
5657: AND zjb.TAX_REGIME_CODE = zrb.TAX_REGIME_CODE
5658: AND zjb.TAX = zrb.TAX
5659: AND zjb.TAX_JURISDICTION_CODE = zrb.TAX_JURISDICTION_CODE

Line 5675: INSERT INTO ZX_RATES_TL

5671: FND_FILE.LOG,
5672: 'Creating TL for Tax Rates.'
5673: );
5674:
5675: INSERT INTO ZX_RATES_TL
5676: (
5677: TAX_RATE_ID,
5678: TAX_RATE_NAME,
5679: CREATED_BY,

Line 5703: FROM ZX_RATES_TL zrt

5699: AND zrb.TAX_REGIME_CODE = p_tax_regime_code
5700: AND zrb.CONTENT_OWNER_ID = -99
5701: AND zrb.TAX IN ('STATE','COUNTY','CITY')
5702: AND NOT EXISTS (SELECT NULL
5703: FROM ZX_RATES_TL zrt
5704: WHERE zrt.TAX_RATE_ID = zrb.TAX_RATE_ID
5705: AND zrt.LANGUAGE = fl.LANGUAGE_CODE);
5706:
5707: FND_FILE.PUT_LINE