[Home] [Help]
2038: WHERE tax_id = L.tax_id) legal_reporting_status,
2039: --End of Bug 7383041
2040: 1
2041: FROM zx_lines L,
2042: zx_lines_det_factors G
2043: WHERE G.event_id = p_event_class_rec.event_id
2044: AND G.ref_doc_application_id IS NOT NULL
2045: AND (G.tax_event_type_code NOT IN ('OVERRIDE_TAX', 'UPDATE')
2046: OR (G.tax_event_type_code ='UPDATE' AND
2607: WHERE tax_id = L.tax_id) legal_reporting_status,
2608: --End of Bug 7383041
2609: 1
2610: FROM zx_lines L,
2611: zx_lines_det_factors G
2612: WHERE G.event_id = p_event_class_rec.event_id
2613: AND G.ref_doc_application_id IS NOT NULL
2614: AND (G.tax_event_type_code NOT IN ('OVERRIDE_TAX', 'UPDATE')
2615: OR (G.tax_event_type_code ='UPDATE' AND
2922: T.tax_status_code,
2923: T.tax_rate_code,
2924: T.tax_determine_date
2925: FROM zx_detail_tax_lines_gt T,
2926: zx_lines_det_factors G
2927: WHERE
2928: -- commented out for bug fix 5417887
2929: -- G.application_id = p_event_class_rec.application_id
2930: --AND G.event_class_code = p_event_class_rec.event_class_code
3194: L.cal_tax_amt,
3195: L.cal_tax_amt_tax_curr,
3196: L.cal_tax_amt_funcl_curr
3197: FROM zx_lines L,
3198: zx_lines_det_factors G
3199: WHERE
3200: -- commented out for bug fix 5417887
3201: -- G.application_id = p_event_class_rec.application_id
3202: --AND G.event_class_code = p_event_class_rec.event_class_code
4423: l_detail_tax_lines_tbl ZX_TDS_CALC_SERVICES_PUB_PKG.detail_tax_lines_tbl_type;
4424: l_tax_index NUMBER;
4425:
4426: -- this procedure is added for PO eBTax uptake. PO calls eBtax only in GT mode,
4427: -- so use zx_transaction_lines_gt in stead of zx_lines_det_factors to retrieve
4428: -- the tax lines for unchanged the trx lines.
4429:
4430: CURSOR c_tx_ln_for_unchanged_trx_ln IS
4431: SELECT L.*