[Home] [Help]
379: cursor c_tax_cnt(cp_draft_invoice_id in number) is
380: select
381: nvl( sum( decode( nvl(c.regime_code,'XX'), 'VAT', 1, 0)), 0) vat_cnt,
382: nvl( sum( decode( upper(b.tax_type), 'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 0)), 0) excise_cnt
383: from jai_cmn_document_taxes b,
384: jai_regime_tax_types_v c
385: where b.source_doc_type = jai_pa_billing_pkg.gv_source_projects
386: and b.tax_type = c.tax_type(+)
387: and b.source_doc_id = cp_draft_invoice_id;
692:
693:
694: cursor c_exists_excise_tax (cpn_draft_invoice_id number) is
695: select 'Y'
696: from jai_cmn_document_taxes
697: where source_doc_type = jai_pa_billing_pkg.gv_source_projects
698: and source_doc_id = cpn_draft_invoice_id
699: and upper(tax_type)
700: in
711: ,round(sum( decode( upper(tax_type),
712: upper(jai_constants.tax_type_exc_edu_cess), func_tax_amt, 0 )), 2) excise_cess
713: ,round(sum( decode( tax_type,
714: jai_constants.tax_type_sh_exc_edu_cess, func_tax_amt, 0 )), 2) sh_excise_cess /*budget07*/
715: from jai_cmn_document_taxes
716: where source_doc_type = jai_pa_billing_pkg.gv_source_projects
717: and source_doc_id = cpn_draft_invoice_id
718: and upper(tax_type)
719: in
1495: -------------------------------------------------------------------------------------
1496:
1497: procedure import_taxes_to_payables
1498: --
1499: -- This procedure imports the taxes from project draft invoice (jai_cmn_document_taxes) to
1500: -- payables (ap_invoice_distributions_all)
1501: --
1502: ( errbuf OUT NOCOPY varchar2
1503: , retcode OUT NOCOPY number
1624: , jcdt.modvat_flag
1625: , jcdt.tax_amt
1626: , jcdt.doc_tax_id
1627: from jai_pa_draft_invoice_lines jpdil
1628: ,jai_cmn_document_taxes jcdt
1629: where jpdil.project_id = cpn_project_id
1630: and jpdil.draft_invoice_num = cpn_draft_invoice_num
1631: and jpdil.line_num = cpn_ar_invoice_line_num
1632: and jpdil.draft_invoice_line_id = jcdt.source_doc_line_id