APPS.OKS_TAX_UTIL_PVT dependencies on ZX_EXEMPTIONS

Line 225: FROM ZX_EXEMPTIONS

221:
222: CURSOR tax_exempt_csr(cp_tax_exempt_id NUMBER) IS
223: SELECT EXEMPT_CERTIFICATE_NUMBER,
224: EXEMPT_REASON_CODE
225: FROM ZX_EXEMPTIONS
226: WHERE TAX_EXEMPTION_ID = cp_tax_exempt_id;
227: TAX_REC tax_exempt_csr%ROWTYPE;
228:
229: --npalepu added on 12-JUL-2006 for bug # 5380878

Line 626: FROM ZX_EXEMPTIONS

622:
623: CURSOR tax_exempt_csr(cp_tax_exempt_id NUMBER) IS
624: SELECT EXEMPT_CERTIFICATE_NUMBER,
625: EXEMPT_REASON_CODE
626: FROM ZX_EXEMPTIONS
627: WHERE TAX_EXEMPTION_ID = cp_tax_exempt_id;
628: TAX_REC tax_exempt_csr%ROWTYPE;
629:
630: --npalepu added on 12-JUL-2006 for bug # 5380878

Line 2301: FROM ZX_EXEMPTIONS zx

2297: --npalepu updating tax_code and tax_exemption_id to null for bug # 4908543
2298: UPDATE /*+ parallel(oks) */ OKS_K_HEADERS_B oks
2299: SET (EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE)
2300: = (SELECT zx.EXEMPT_CERTIFICATE_NUMBER, zx.EXEMPT_REASON_CODE
2301: FROM ZX_EXEMPTIONS zx
2302: WHERE zx.TAX_EXEMPTION_ID = oks.tax_exemption_id)
2303: ,TAX_EXEMPTION_ID = NULL
2304: ,TAX_CODE = NULL
2305: WHERE oks.tax_exemption_id IS NOT NULL

Line 2317: FROM ZX_EXEMPTIONS zx

2313: updating tax_code and tax_exemption_id to null for bug # 4908543 */
2314: UPDATE /*+ parallel(oks) */ OKS_K_HEADERS_BH oks
2315: SET (EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE)
2316: = (SELECT zx.EXEMPT_CERTIFICATE_NUMBER, zx.EXEMPT_REASON_CODE
2317: FROM ZX_EXEMPTIONS zx
2318: WHERE zx.TAX_EXEMPTION_ID = oks.tax_exemption_id)
2319: ,TAX_EXEMPTION_ID = NULL
2320: ,TAX_CODE = NULL
2321: WHERE oks.tax_exemption_id IS NOT NULL

Line 2494: FROM RA_TAX_EXEMPTIONS_ALL zx /* npalepu replaced ZX_EXEMPTIONS with RA_TAX_EXEMPTIONS_ALL for bug # 4908543. */

2490: (oks1.EXEMPT_CERTIFICATE_NUMBER IS NULL
2491: OR oks1.EXEMPT_REASON_CODE IS NULL))
2492: THEN
2493: (SELECT zx.CUSTOMER_EXEMPTION_NUMBER /* npalepu replaced zx.EXEMPT_CERTIFICATE_NUMBER with zx.CUSTOMER_EXEMPTION_NUMBER for bug # 4908543. */
2494: FROM RA_TAX_EXEMPTIONS_ALL zx /* npalepu replaced ZX_EXEMPTIONS with RA_TAX_EXEMPTIONS_ALL for bug # 4908543. */
2495: WHERE zx.TAX_EXEMPTION_ID = oks1.TAX_EXEMPTION_ID )
2496: ELSE
2497: oks1.EXEMPT_CERTIFICATE_NUMBER
2498: END)

Line 2505: FROM RA_TAX_EXEMPTIONS_ALL zx /* npalepu replaced ZX_EXEMPTIONS with RA_TAX_EXEMPTIONS_ALL by bug # 4908543. */

2501: (oks1.EXEMPT_CERTIFICATE_NUMBER IS NULL
2502: OR oks1.EXEMPT_REASON_CODE IS NULL))
2503: THEN
2504: (SELECT zx.REASON_CODE /* npalepu replaced zx.EXEMPT_REASON_CODE with zx.REASON_CODE for bug # 4908543. */
2505: FROM RA_TAX_EXEMPTIONS_ALL zx /* npalepu replaced ZX_EXEMPTIONS with RA_TAX_EXEMPTIONS_ALL by bug # 4908543. */
2506: WHERE zx.TAX_EXEMPTION_ID = oks1.TAX_EXEMPTION_ID )
2507: ELSE
2508: oks1.EXEMPT_REASON_CODE
2509: END)

Line 2634: FROM RA_TAX_EXEMPTIONS_ALL zx /* npalepu replaced ZX_EXEMPTIONS with RA_TAX_EXEMPTIONS_ALL for bug # 4908543. */

2630: (oks1.EXEMPT_CERTIFICATE_NUMBER IS NULL
2631: OR oks1.EXEMPT_REASON_CODE IS NULL))
2632: THEN
2633: (SELECT zx.CUSTOMER_EXEMPTION_NUMBER /* npalepu replaced zx.EXEMPT_CERTIFICATE_NUMBER with zx.CUSTOMER_EXEMPTION_NUMBER for bug # 4908543. */
2634: FROM RA_TAX_EXEMPTIONS_ALL zx /* npalepu replaced ZX_EXEMPTIONS with RA_TAX_EXEMPTIONS_ALL for bug # 4908543. */
2635: WHERE zx.TAX_EXEMPTION_ID = oks1.TAX_EXEMPTION_ID )
2636: ELSE
2637: oks1.EXEMPT_CERTIFICATE_NUMBER
2638: END)

Line 2645: FROM RA_TAX_EXEMPTIONS_ALL zx /* npalepu replaced ZX_EXEMPTIONS with RA_TAX_EXEMPTIONS_ALL for bug # 4908543. */

2641: (oks1.EXEMPT_CERTIFICATE_NUMBER IS NULL
2642: OR oks1.EXEMPT_REASON_CODE IS NULL))
2643: THEN
2644: (SELECT zx.REASON_CODE /* npalepu replaced zx.EXEMPT_REASON_CODE with zx.REASON_CODE for bug # 4908543. */
2645: FROM RA_TAX_EXEMPTIONS_ALL zx /* npalepu replaced ZX_EXEMPTIONS with RA_TAX_EXEMPTIONS_ALL for bug # 4908543. */
2646: WHERE zx.TAX_EXEMPTION_ID = oks1.TAX_EXEMPTION_ID )
2647: ELSE
2648: oks1.EXEMPT_REASON_CODE
2649: END)