[Home] [Help]
361: AND nvl(jcta.inclusive_tax_flag,'N') <> 'Y'
362: AND jcdt.source_doc_line_id = aida.invoice_line_number
363: AND aida.accounting_date <= cd_as_of_date
364: --Added by Qiong for reverse charge bug#16001407, begin
365: AND jai_cmn_reverse_charge_pkg.is_reverse_charge_dist(aida.invoice_distribution_id)<> 'Y';
366: --Added by Qiong for reverse charge bug#16001407 begin
367:
368: CURSOR c_sum_rv_st_tax_amt_standard(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_as_of_date DATE) IS
369: SELECT sum(jcdt.tax_amt)
380: AND jcdt.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS')
381: AND NVL(jcdt.modvat_flag,'N')='Y'
382: AND aida.accounting_date <= cd_as_of_date
383: --Added by Qiong for reverse charge bug#16001407 begin
384: AND jai_cmn_reverse_charge_pkg.is_reverse_charge_dist(aida.invoice_distribution_id)<> 'Y';
385: --Added by Qiong for reverse charge bug#16001407 begin
386:
387:
388: CURSOR c_sum_all_tax_amt_matched(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_as_of_date DATE, cp_match_type VARCHAR2) IS