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 5219: UPDATE ZX_TAXES_B_TMP tax

5215:
5216: l_rows_processed := SQL%ROWCOUNT;
5217:
5218: -- make the tax live for processing if there is atleast one rate defined for the tax
5219: UPDATE ZX_TAXES_B_TMP tax
5220: SET tax.LIVE_FOR_PROCESSING_FLAG = 'Y'
5221: WHERE tax.RECORD_TYPE_CODE = G_CREATED_BY_MODULE
5222: AND tax.TAX_REGIME_CODE = p_tax_regime_code
5223: AND EXISTS (SELECT 1