APPS.OKS_ARFEEDER_PUB dependencies on ZX_EXEMPTIONS

Line 2497: FROM zx_exemptions v2

2493: Cursor Cur_tax(id_in IN VARCHAR2,l_trx_date IN DATE) IS
2494: --Start fixes of eBTax uptake bug#4756579
2495: SELECT v2.exempt_certificate_number,
2496: v2.exempt_reason_code
2497: FROM zx_exemptions v2
2498: WHERE (trunc(l_trx_date) BETWEEN trunc(v2.EFFECTIVE_FROM)
2499: AND nvl( trunc(v2.EFFECTIVE_TO), trunc(l_trx_date)))
2500: AND v2.tax_exemption_id = id_in;
2501: --End fixes of eBTax uptake bug#4756579

Line 2514: FROM zx_exemptions v2

2510:
2511: Cursor Cur_valid_exemption(p_exempt_number IN VARCHAR2, p_trx_date IN DATE) IS
2512: SELECT v2.exempt_certificate_number,
2513: v2.exempt_reason_code
2514: FROM zx_exemptions v2
2515: WHERE (trunc(p_trx_date) BETWEEN trunc(v2.EFFECTIVE_FROM)
2516: AND nvl( trunc(v2.EFFECTIVE_TO), trunc(p_trx_date)))
2517: AND v2.exempt_certificate_number = p_exempt_number;
2518:

Line 3319: --and exempt_reasion_code from zx_exemptions

3315: --Rewritten the tax code for R12 eBTax uptake
3316: --For exemptions:
3317: --(1)if exemption_certificate_number is populated, use that
3318: --(2)otherwise use tax_exemption_id to query exempt_certificate_number
3319: --and exempt_reasion_code from zx_exemptions
3320:
3321: IF (rul_hdr_rec.tax_status IS NOT NULL) THEN
3322: G_RAIL_REC.TAX_EXEMPT_FLAG := rul_hdr_rec.tax_status;
3323: -- added cur_date_trans cursor for tax exemption and modified the if condition to

Line 3466: --and exempt_reasion_code from zx_exemptions

3462:
3463: --For exemptions:
3464: --(1)if exemption_certificate_number is populated, use that
3465: --(2)otherwise use tax_exemption_id to query exempt_certificate_number
3466: --and exempt_reasion_code from zx_exemptions
3467:
3468: IF ( Rul_line_rec.tax_status IS NOT NULL OR
3469: Rul_line_rec.tax_classification_code IS NOT NULL OR
3470: Rul_line_rec.tax_code IS NOT NULL ) Then