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 646: FROM ZX_EXEMPTIONS

642:
643: CURSOR tax_exempt_csr(cp_tax_exempt_id NUMBER) IS
644: SELECT EXEMPT_CERTIFICATE_NUMBER,
645: EXEMPT_REASON_CODE
646: FROM ZX_EXEMPTIONS
647: WHERE TAX_EXEMPTION_ID = cp_tax_exempt_id;
648: TAX_REC tax_exempt_csr%ROWTYPE;
649:
650: --npalepu added on 12-JUL-2006 for bug # 5380878

Line 2349: FROM ZX_EXEMPTIONS zx

2345: --npalepu updating tax_code and tax_exemption_id to null for bug # 4908543
2346: UPDATE /*+ parallel(oks) */ OKS_K_HEADERS_B oks
2347: SET (EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE)
2348: = (SELECT zx.EXEMPT_CERTIFICATE_NUMBER, zx.EXEMPT_REASON_CODE
2349: FROM ZX_EXEMPTIONS zx
2350: WHERE zx.TAX_EXEMPTION_ID = oks.tax_exemption_id)
2351: ,TAX_EXEMPTION_ID = NULL
2352: ,TAX_CODE = NULL
2353: WHERE oks.tax_exemption_id IS NOT NULL

Line 2365: FROM ZX_EXEMPTIONS zx

2361: updating tax_code and tax_exemption_id to null for bug # 4908543 */
2362: UPDATE /*+ parallel(oks) */ OKS_K_HEADERS_BH oks
2363: SET (EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE)
2364: = (SELECT zx.EXEMPT_CERTIFICATE_NUMBER, zx.EXEMPT_REASON_CODE
2365: FROM ZX_EXEMPTIONS zx
2366: WHERE zx.TAX_EXEMPTION_ID = oks.tax_exemption_id)
2367: ,TAX_EXEMPTION_ID = NULL
2368: ,TAX_CODE = NULL
2369: WHERE oks.tax_exemption_id IS NOT NULL

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

2538: (oks1.EXEMPT_CERTIFICATE_NUMBER IS NULL
2539: OR oks1.EXEMPT_REASON_CODE IS NULL))
2540: THEN
2541: (SELECT zx.CUSTOMER_EXEMPTION_NUMBER /* npalepu replaced zx.EXEMPT_CERTIFICATE_NUMBER with zx.CUSTOMER_EXEMPTION_NUMBER for bug # 4908543. */
2542: FROM RA_TAX_EXEMPTIONS_ALL zx /* npalepu replaced ZX_EXEMPTIONS with RA_TAX_EXEMPTIONS_ALL for bug # 4908543. */
2543: WHERE zx.TAX_EXEMPTION_ID = oks1.TAX_EXEMPTION_ID )
2544: ELSE
2545: oks1.EXEMPT_CERTIFICATE_NUMBER
2546: END)

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

2549: (oks1.EXEMPT_CERTIFICATE_NUMBER IS NULL
2550: OR oks1.EXEMPT_REASON_CODE IS NULL))
2551: THEN
2552: (SELECT zx.REASON_CODE /* npalepu replaced zx.EXEMPT_REASON_CODE with zx.REASON_CODE for bug # 4908543. */
2553: FROM RA_TAX_EXEMPTIONS_ALL zx /* npalepu replaced ZX_EXEMPTIONS with RA_TAX_EXEMPTIONS_ALL by bug # 4908543. */
2554: WHERE zx.TAX_EXEMPTION_ID = oks1.TAX_EXEMPTION_ID )
2555: ELSE
2556: oks1.EXEMPT_REASON_CODE
2557: END)

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

2678: (oks1.EXEMPT_CERTIFICATE_NUMBER IS NULL
2679: OR oks1.EXEMPT_REASON_CODE IS NULL))
2680: THEN
2681: (SELECT zx.CUSTOMER_EXEMPTION_NUMBER /* npalepu replaced zx.EXEMPT_CERTIFICATE_NUMBER with zx.CUSTOMER_EXEMPTION_NUMBER for bug # 4908543. */
2682: FROM RA_TAX_EXEMPTIONS_ALL zx /* npalepu replaced ZX_EXEMPTIONS with RA_TAX_EXEMPTIONS_ALL for bug # 4908543. */
2683: WHERE zx.TAX_EXEMPTION_ID = oks1.TAX_EXEMPTION_ID )
2684: ELSE
2685: oks1.EXEMPT_CERTIFICATE_NUMBER
2686: END)

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

2689: (oks1.EXEMPT_CERTIFICATE_NUMBER IS NULL
2690: OR oks1.EXEMPT_REASON_CODE IS NULL))
2691: THEN
2692: (SELECT zx.REASON_CODE /* npalepu replaced zx.EXEMPT_REASON_CODE with zx.REASON_CODE for bug # 4908543. */
2693: FROM RA_TAX_EXEMPTIONS_ALL zx /* npalepu replaced ZX_EXEMPTIONS with RA_TAX_EXEMPTIONS_ALL for bug # 4908543. */
2694: WHERE zx.TAX_EXEMPTION_ID = oks1.TAX_EXEMPTION_ID )
2695: ELSE
2696: oks1.EXEMPT_REASON_CODE
2697: END)