APPS.ZX_TAX_CONTENT_UPLOAD dependencies on ZX_RATES_TL

Line 5176: FROM ZX_RATES_TL zrt

5172: AND zrb.TAX IN ('STATE','COUNTY','CITY')
5173: AND zrb.CONTENT_OWNER_ID = -99
5174: AND zrb.RECORD_TYPE_CODE = G_CREATED_BY_MODULE
5175: AND NOT EXISTS (SELECT NULL
5176: FROM ZX_RATES_TL zrt
5177: WHERE zrt.TAX_RATE_ID = zrb.TAX_RATE_ID)
5178: AND zjb.TAX_REGIME_CODE = zrb.TAX_REGIME_CODE
5179: AND zjb.TAX = zrb.TAX
5180: AND zjb.TAX_JURISDICTION_CODE = zrb.TAX_JURISDICTION_CODE

Line 5184: INSERT INTO ZX_RATES_TL

5180: AND zjb.TAX_JURISDICTION_CODE = zrb.TAX_JURISDICTION_CODE
5181: AND za.TAX_ACCOUNT_ENTITY_CODE = 'JURISDICTION'
5182: AND za.TAX_ACCOUNT_ENTITY_ID = zjb.TAX_JURISDICTION_ID;
5183:
5184: INSERT INTO ZX_RATES_TL
5185: (
5186: TAX_RATE_ID,
5187: TAX_RATE_NAME,
5188: CREATED_BY,

Line 5212: FROM ZX_RATES_TL zrt

5208: AND zrb.TAX_REGIME_CODE = p_tax_regime_code
5209: AND zrb.CONTENT_OWNER_ID = -99
5210: AND zrb.TAX IN ('STATE','COUNTY','CITY')
5211: AND NOT EXISTS (SELECT NULL
5212: FROM ZX_RATES_TL zrt
5213: WHERE zrt.TAX_RATE_ID = zrb.TAX_RATE_ID
5214: AND zrt.LANGUAGE = fl.LANGUAGE_CODE);
5215:
5216: l_rows_processed := SQL%ROWCOUNT;