DBA Data[Home] [Help]

APPS.ZX_TAX_CONTENT_UPLOAD dependencies on ZX_TAXES_B_TMP

Line 116: INSERT INTO ZX_TAXES_B_TMP

112: FND_FILE.LOG,
113: 'Creating Tax: '||l_tax||'.'
114: );
115:
116: INSERT INTO ZX_TAXES_B_TMP
117: (
118: TAX ,
119: EFFECTIVE_FROM ,
120: EFFECTIVE_TO ,

Line 5716: UPDATE ZX_TAXES_B_TMP tax

5712:
5713: l_rows_processed := SQL%ROWCOUNT;
5714:
5715: -- make the tax live for processing if there is atleast one rate defined for the tax
5716: UPDATE ZX_TAXES_B_TMP tax
5717: SET tax.LIVE_FOR_PROCESSING_FLAG = 'Y'
5718: WHERE tax.RECORD_TYPE_CODE = G_CREATED_BY_MODULE
5719: AND tax.TAX_REGIME_CODE = p_tax_regime_code
5720: AND tax.CONTENT_OWNER_ID = -99 -- Condition Added as a fix for Bug#8286647