APPS.OKS_TAX_UTIL_PVT dependencies on RA_TAX_EXEMPTIONS_ALL

Line 232: FROM RA_TAX_EXEMPTIONS_ALL ex

228:
229: --npalepu added on 12-JUL-2006 for bug # 5380878
230: CURSOR get_taxcode_from_taxexempt_csr(cp_tax_exempt_id NUMBER) IS
231: SELECT ex.TAX_CODE
232: FROM RA_TAX_EXEMPTIONS_ALL ex
233: WHERE ex.TAX_EXEMPTION_ID = cp_tax_exempt_id;
234: --end npalepu
235:
236: CURSOR tax_code_csr(cp_tax_code VARCHAR2) IS

Line 633: FROM RA_TAX_EXEMPTIONS_ALL ex

629:
630: --npalepu added on 12-JUL-2006 for bug # 5380878
631: CURSOR get_taxcode_from_taxexempt_csr(cp_tax_exempt_id NUMBER) IS
632: SELECT ex.TAX_CODE
633: FROM RA_TAX_EXEMPTIONS_ALL ex
634: WHERE ex.TAX_EXEMPTION_ID = cp_tax_exempt_id;
635: --end npalepu
636:
637: CURSOR tax_code_csr(cp_tax_code VARCHAR2) IS

Line 2482: FROM RA_TAX_EXEMPTIONS_ALL zx

2478: --npalepu added on 29-jun-2006 for bug # 4908543
2479: WHEN (oks1.TAX_EXEMPTION_ID IS NOT NULL)
2480: THEN
2481: (SELECT zx.TAX_CODE
2482: FROM RA_TAX_EXEMPTIONS_ALL zx
2483: WHERE zx.TAX_EXEMPTION_ID = oks1.TAX_EXEMPTION_ID )
2484: --end npalepu
2485: ELSE
2486: oks1.TAX_CLASSIFICATION_CODE

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 2622: FROM RA_TAX_EXEMPTIONS_ALL zx

2618: --npalepu added on 29-jun-2006 for bug # 4908543
2619: WHEN (oks1.TAX_EXEMPTION_ID IS NOT NULL)
2620: THEN
2621: (SELECT zx.TAX_CODE
2622: FROM RA_TAX_EXEMPTIONS_ALL zx
2623: WHERE zx.TAX_EXEMPTION_ID = oks1.TAX_EXEMPTION_ID )
2624: --end npalepu
2625: ELSE
2626: oks1.TAX_CLASSIFICATION_CODE

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)