DBA Data[Home] [Help]

APPS.OKS_ARFEEDER_PUB dependencies on ZX_ID_TCC_MAPPING

Line 2507: FROM zx_id_tcc_mapping

2503:
2504: Cursor cur_tax_code (p_id IN VARCHAR2, p_org_id NUMBER) IS
2505: --Start fixes of eBTax uptake bug#4756579
2506: SELECT tax_classification_code
2507: FROM zx_id_tcc_mapping
2508: WHERE tax_rate_code_id = p_id
2509: AND org_id = p_org_id;
2510:
2511: Cursor Cur_valid_exemption(p_exempt_number IN VARCHAR2, p_trx_date IN DATE) IS

Line 3577: --from zx_id_tcc_mapping

3573:
3574: --For tax classification code:
3575: --(1)if tax_classification_code is not null, use that
3576: --(2)otherwise use the old tax_code and query tax_classification_code
3577: --from zx_id_tcc_mapping
3578: IF (Rul_line_rec.tax_classification_code IS NOT NULL) THEN
3579: --new contracts
3580: G_RAIL_REC.TAX_CODE := Rul_line_rec.tax_classification_code;
3581: If G_LOG_YES_NO = 'YES' then