APPS.OKS_ARFEEDER_PUB dependencies on ZX_EXEMPTIONS

Line 2478: FROM zx_exemptions v2

2474: Cursor Cur_tax(id_in IN VARCHAR2,l_trx_date IN DATE) IS
2475: --Start fixes of eBTax uptake bug#4756579
2476: SELECT v2.exempt_certificate_number,
2477: v2.exempt_reason_code
2478: FROM zx_exemptions v2
2479: WHERE (trunc(l_trx_date) BETWEEN trunc(v2.EFFECTIVE_FROM)
2480: AND nvl( trunc(v2.EFFECTIVE_TO), trunc(l_trx_date)))
2481: AND v2.tax_exemption_id = id_in;
2482: --End fixes of eBTax uptake bug#4756579

Line 2495: FROM zx_exemptions v2

2491:
2492: Cursor Cur_valid_exemption(p_exempt_number IN VARCHAR2, p_trx_date IN DATE) IS
2493: SELECT v2.exempt_certificate_number,
2494: v2.exempt_reason_code
2495: FROM zx_exemptions v2
2496: WHERE (trunc(p_trx_date) BETWEEN trunc(v2.EFFECTIVE_FROM)
2497: AND nvl( trunc(v2.EFFECTIVE_TO), trunc(p_trx_date)))
2498: AND v2.exempt_certificate_number = p_exempt_number;
2499:

Line 3270: --and exempt_reasion_code from zx_exemptions

3266: --Rewritten the tax code for R12 eBTax uptake
3267: --For exemptions:
3268: --(1)if exemption_certificate_number is populated, use that
3269: --(2)otherwise use tax_exemption_id to query exempt_certificate_number
3270: --and exempt_reasion_code from zx_exemptions
3271:
3272: IF (rul_hdr_rec.tax_status IS NOT NULL) THEN
3273: G_RAIL_REC.TAX_EXEMPT_FLAG := rul_hdr_rec.tax_status;
3274: -- added cur_date_trans cursor for tax exemption and modified the if condition to

Line 3415: --and exempt_reasion_code from zx_exemptions

3411:
3412: --For exemptions:
3413: --(1)if exemption_certificate_number is populated, use that
3414: --(2)otherwise use tax_exemption_id to query exempt_certificate_number
3415: --and exempt_reasion_code from zx_exemptions
3416:
3417: IF ( Rul_line_rec.tax_status IS NOT NULL OR
3418: Rul_line_rec.tax_classification_code IS NOT NULL OR
3419: Rul_line_rec.tax_code IS NOT NULL ) Then