DBA Data[Home] [Help]

APPS.OKS_TAX_UTIL_PVT dependencies on ZX_ID_TCC_MAPPING_ALL

Line 2523: 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 */

2519: set TAX_CLASSIFICATION_CODE = (CASE WHEN oks1.TAX_CODE IS NOT NULL
2520: AND oks1.TAX_CLASSIFICATION_CODE IS NULL
2521: THEN
2522: (SELECT zx.TAX_CLASSIFICATION_CODE
2523: 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 */
2524: WHERE zx.TAX_RATE_CODE_ID = oks1.TAX_CODE
2525: AND zx.SOURCE = 'AR')
2526: --npalepu added on 29-jun-2006 for bug # 4908543
2527: WHEN (oks1.TAX_EXEMPTION_ID IS NOT NULL)

Line 2663: 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 */

2659: set TAX_CLASSIFICATION_CODE = (CASE WHEN oks1.TAX_CODE IS NOT NULL
2660: AND oks1.TAX_CLASSIFICATION_CODE IS NULL
2661: THEN
2662: (SELECT zx.TAX_CLASSIFICATION_CODE
2663: 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 */
2664: WHERE zx.TAX_RATE_CODE_ID = oks1.TAX_CODE
2665: AND zx.SOURCE = 'AR')
2666: --npalepu added on 29-jun-2006 for bug # 4908543
2667: WHEN (oks1.TAX_EXEMPTION_ID IS NOT NULL)