DBA Data[Home] [Help]

APPS.OKS_TAX_UTIL_PVT dependencies on ZX_ID_TCC_MAPPING_ALL

Line 2475: FROM ZX_ID_TCC_MAPPING_ALL zx /* npalepu replaced ZX_ID_TCC_MAPPING with ZX_ID_TCC_MAPPING_ALL on 29-jun-2006 for bug # 4908543 */

2471: set TAX_CLASSIFICATION_CODE = (CASE WHEN oks1.TAX_CODE IS NOT NULL
2472: AND oks1.TAX_CLASSIFICATION_CODE IS NULL
2473: THEN
2474: (SELECT zx.TAX_CLASSIFICATION_CODE
2475: FROM ZX_ID_TCC_MAPPING_ALL zx /* npalepu replaced ZX_ID_TCC_MAPPING with ZX_ID_TCC_MAPPING_ALL on 29-jun-2006 for bug # 4908543 */
2476: WHERE zx.TAX_RATE_CODE_ID = oks1.TAX_CODE
2477: AND zx.SOURCE = 'AR')
2478: --npalepu added on 29-jun-2006 for bug # 4908543
2479: WHEN (oks1.TAX_EXEMPTION_ID IS NOT NULL)

Line 2615: FROM ZX_ID_TCC_MAPPING_ALL zx /* npalepu replaced ZX_ID_TCC_MAPPING with ZX_ID_TCC_MAPPING_ALL on 29-jun-2006 for bug # 4908543 */

2611: set TAX_CLASSIFICATION_CODE = (CASE WHEN oks1.TAX_CODE IS NOT NULL
2612: AND oks1.TAX_CLASSIFICATION_CODE IS NULL
2613: THEN
2614: (SELECT zx.TAX_CLASSIFICATION_CODE
2615: FROM ZX_ID_TCC_MAPPING_ALL zx /* npalepu replaced ZX_ID_TCC_MAPPING with ZX_ID_TCC_MAPPING_ALL on 29-jun-2006 for bug # 4908543 */
2616: WHERE zx.TAX_RATE_CODE_ID = oks1.TAX_CODE
2617: AND zx.SOURCE = 'AR')
2618: --npalepu added on 29-jun-2006 for bug # 4908543
2619: WHEN (oks1.TAX_EXEMPTION_ID IS NOT NULL)