535: AND jcta.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS');
536:
537: CURSOR get_total_arrec_amt_cur IS
538: SELECT SUM(jattl.tax_amount * nvl(jcta.mod_cr_percentage,0)/100) tax_amt
539: FROM jai_ar_trx_tax_lines jattl
540: , jai_ar_trx_lines jatl
541: , jai_cmn_taxes_all jcta
542: WHERE jatl.customer_trx_id = pn_invoice_id
543: AND jattl.link_to_cust_trx_line_id = jatl.customer_trx_line_id
594:
595: CURSOR get_tax_type_ar_cur IS
596: SELECT jcta.tax_type, jattl.tax_amount * nvl(jcta.mod_cr_percentage,0)/100 tax_amt,
597: jattl.customer_trx_line_id
598: FROM jai_ar_trx_tax_lines jattl
599: , ra_customer_trx_lines_all trxl
600: , jai_cmn_taxes_all jcta
601: WHERE jattl.link_to_cust_trx_line_id = pn_line_number
602: AND trxl.customer_trx_id = pn_invoice_id