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 653: FROM RA_TAX_EXEMPTIONS_ALL ex

649:
650: --npalepu added on 12-JUL-2006 for bug # 5380878
651: CURSOR get_taxcode_from_taxexempt_csr(cp_tax_exempt_id NUMBER) IS
652: SELECT ex.TAX_CODE
653: FROM RA_TAX_EXEMPTIONS_ALL ex
654: WHERE ex.TAX_EXEMPTION_ID = cp_tax_exempt_id;
655: --end npalepu
656:
657: CURSOR tax_code_csr(cp_tax_code VARCHAR2) IS

Line 2530: FROM RA_TAX_EXEMPTIONS_ALL zx

2526: --npalepu added on 29-jun-2006 for bug # 4908543
2527: WHEN (oks1.TAX_EXEMPTION_ID IS NOT NULL)
2528: THEN
2529: (SELECT zx.TAX_CODE
2530: FROM RA_TAX_EXEMPTIONS_ALL zx
2531: WHERE zx.TAX_EXEMPTION_ID = oks1.TAX_EXEMPTION_ID )
2532: --end npalepu
2533: ELSE
2534: oks1.TAX_CLASSIFICATION_CODE

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

2666: --npalepu added on 29-jun-2006 for bug # 4908543
2667: WHEN (oks1.TAX_EXEMPTION_ID IS NOT NULL)
2668: THEN
2669: (SELECT zx.TAX_CODE
2670: FROM RA_TAX_EXEMPTIONS_ALL zx
2671: WHERE zx.TAX_EXEMPTION_ID = oks1.TAX_EXEMPTION_ID )
2672: --end npalepu
2673: ELSE
2674: oks1.TAX_CLASSIFICATION_CODE

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)