492: v_tax_amt := c_get_tax_from_ap_rec.tax_amount;
493:
494: v_statement_id:= 10;
495:
496: if v_tax_type in (UPPER(jai_constants.tax_type_exc_additional), UPPER(jai_constants.tax_type_excise),UPPER(jai_constants.tax_type_exc_other),
497: UPPER(jai_constants.tax_type_exc_edu_cess), UPPER(jai_constants.tax_type_sh_exc_edu_cess)) then --Added cess and sh cess for bug #16426218
498: v_excise_ap := v_excise_ap + v_tax_amt;
499: elsif v_tax_type = UPPER(jai_constants. tax_type_cst) then
500: v_cst_ap := v_cst_ap + v_tax_amt;
493:
494: v_statement_id:= 10;
495:
496: if v_tax_type in (UPPER(jai_constants.tax_type_exc_additional), UPPER(jai_constants.tax_type_excise),UPPER(jai_constants.tax_type_exc_other),
497: UPPER(jai_constants.tax_type_exc_edu_cess), UPPER(jai_constants.tax_type_sh_exc_edu_cess)) then --Added cess and sh cess for bug #16426218
498: v_excise_ap := v_excise_ap + v_tax_amt;
499: elsif v_tax_type = UPPER(jai_constants. tax_type_cst) then
500: v_cst_ap := v_cst_ap + v_tax_amt;
501: elsif v_tax_type = UPPER(jai_constants.tax_type_sales) then
495:
496: if v_tax_type in (UPPER(jai_constants.tax_type_exc_additional), UPPER(jai_constants.tax_type_excise),UPPER(jai_constants.tax_type_exc_other),
497: UPPER(jai_constants.tax_type_exc_edu_cess), UPPER(jai_constants.tax_type_sh_exc_edu_cess)) then --Added cess and sh cess for bug #16426218
498: v_excise_ap := v_excise_ap + v_tax_amt;
499: elsif v_tax_type = UPPER(jai_constants. tax_type_cst) then
500: v_cst_ap := v_cst_ap + v_tax_amt;
501: elsif v_tax_type = UPPER(jai_constants.tax_type_sales) then
502: v_lst_ap := v_lst_ap + v_tax_amt;
503: elsif v_tax_type = UPPER(jai_constants.tax_type_customs) then
497: UPPER(jai_constants.tax_type_exc_edu_cess), UPPER(jai_constants.tax_type_sh_exc_edu_cess)) then --Added cess and sh cess for bug #16426218
498: v_excise_ap := v_excise_ap + v_tax_amt;
499: elsif v_tax_type = UPPER(jai_constants. tax_type_cst) then
500: v_cst_ap := v_cst_ap + v_tax_amt;
501: elsif v_tax_type = UPPER(jai_constants.tax_type_sales) then
502: v_lst_ap := v_lst_ap + v_tax_amt;
503: elsif v_tax_type = UPPER(jai_constants.tax_type_customs) then
504: v_customs_ap := v_customs_ap + v_tax_amt;
505: elsif v_tax_type = UPPER(jai_constants.tax_type_cvd) then
499: elsif v_tax_type = UPPER(jai_constants. tax_type_cst) then
500: v_cst_ap := v_cst_ap + v_tax_amt;
501: elsif v_tax_type = UPPER(jai_constants.tax_type_sales) then
502: v_lst_ap := v_lst_ap + v_tax_amt;
503: elsif v_tax_type = UPPER(jai_constants.tax_type_customs) then
504: v_customs_ap := v_customs_ap + v_tax_amt;
505: elsif v_tax_type = UPPER(jai_constants.tax_type_cvd) then
506: v_cvd_ap := v_cvd_ap + v_tax_amt;
507: -- Date 01-NOV-2006 Bug 5228046 added by SACSETHI
501: elsif v_tax_type = UPPER(jai_constants.tax_type_sales) then
502: v_lst_ap := v_lst_ap + v_tax_amt;
503: elsif v_tax_type = UPPER(jai_constants.tax_type_customs) then
504: v_customs_ap := v_customs_ap + v_tax_amt;
505: elsif v_tax_type = UPPER(jai_constants.tax_type_cvd) then
506: v_cvd_ap := v_cvd_ap + v_tax_amt;
507: -- Date 01-NOV-2006 Bug 5228046 added by SACSETHI
508: -- START BUG 5228046
509: elsif v_tax_type = UPPER(jai_constants.tax_type_add_cvd) then
505: elsif v_tax_type = UPPER(jai_constants.tax_type_cvd) then
506: v_cvd_ap := v_cvd_ap + v_tax_amt;
507: -- Date 01-NOV-2006 Bug 5228046 added by SACSETHI
508: -- START BUG 5228046
509: elsif v_tax_type = UPPER(jai_constants.tax_type_add_cvd) then
510: v_addcvd_ap := v_addcvd_ap + v_tax_amt;
511: -- END BUG 5228046
512: -- Date 24-Nov-2006 Forward porting Bug 5671126 added by Balaji
513: --start
510: v_addcvd_ap := v_addcvd_ap + v_tax_amt;
511: -- END BUG 5228046
512: -- Date 24-Nov-2006 Forward porting Bug 5671126 added by Balaji
513: --start
514: elsif v_tax_type = UPPER(jai_constants.tax_type_value_added) then
515: v_vat_ap := v_vat_ap + v_tax_amt;
516: elsif v_tax_type = UPPER(jai_constants.tax_type_purchase) then
517: v_pur_ap := v_pur_ap + v_tax_amt;
518: elsif v_tax_type = UPPER(jai_constants.tax_type_turnover) then
512: -- Date 24-Nov-2006 Forward porting Bug 5671126 added by Balaji
513: --start
514: elsif v_tax_type = UPPER(jai_constants.tax_type_value_added) then
515: v_vat_ap := v_vat_ap + v_tax_amt;
516: elsif v_tax_type = UPPER(jai_constants.tax_type_purchase) then
517: v_pur_ap := v_pur_ap + v_tax_amt;
518: elsif v_tax_type = UPPER(jai_constants.tax_type_turnover) then
519: v_turnover_ap := v_turnover_ap + v_tax_amt;
520: elsif v_tax_type = UPPER(jai_constants.tax_type_entry) then
514: elsif v_tax_type = UPPER(jai_constants.tax_type_value_added) then
515: v_vat_ap := v_vat_ap + v_tax_amt;
516: elsif v_tax_type = UPPER(jai_constants.tax_type_purchase) then
517: v_pur_ap := v_pur_ap + v_tax_amt;
518: elsif v_tax_type = UPPER(jai_constants.tax_type_turnover) then
519: v_turnover_ap := v_turnover_ap + v_tax_amt;
520: elsif v_tax_type = UPPER(jai_constants.tax_type_entry) then
521: v_entry_ap := v_entry_ap + v_tax_amt;
522: elsif v_tax_type = UPPER(jai_constants.tax_type_service) then
516: elsif v_tax_type = UPPER(jai_constants.tax_type_purchase) then
517: v_pur_ap := v_pur_ap + v_tax_amt;
518: elsif v_tax_type = UPPER(jai_constants.tax_type_turnover) then
519: v_turnover_ap := v_turnover_ap + v_tax_amt;
520: elsif v_tax_type = UPPER(jai_constants.tax_type_entry) then
521: v_entry_ap := v_entry_ap + v_tax_amt;
522: elsif v_tax_type = UPPER(jai_constants.tax_type_service) then
523: v_service_ap := v_service_ap + v_tax_amt;
524: --end
518: elsif v_tax_type = UPPER(jai_constants.tax_type_turnover) then
519: v_turnover_ap := v_turnover_ap + v_tax_amt;
520: elsif v_tax_type = UPPER(jai_constants.tax_type_entry) then
521: v_entry_ap := v_entry_ap + v_tax_amt;
522: elsif v_tax_type = UPPER(jai_constants.tax_type_service) then
523: v_service_ap := v_service_ap + v_tax_amt;
524: --end
525: elsif v_tax_type = UPPER(jai_constants.tax_type_freight) then
526: v_freight_ap := v_freight_ap + v_tax_amt;
521: v_entry_ap := v_entry_ap + v_tax_amt;
522: elsif v_tax_type = UPPER(jai_constants.tax_type_service) then
523: v_service_ap := v_service_ap + v_tax_amt;
524: --end
525: elsif v_tax_type = UPPER(jai_constants.tax_type_freight) then
526: v_freight_ap := v_freight_ap + v_tax_amt;
527: elsif v_tax_type= UPPER(jai_constants.tax_type_octroi) then
528: v_octroi_ap := v_octroi_ap + v_tax_amt;
529: else
523: v_service_ap := v_service_ap + v_tax_amt;
524: --end
525: elsif v_tax_type = UPPER(jai_constants.tax_type_freight) then
526: v_freight_ap := v_freight_ap + v_tax_amt;
527: elsif v_tax_type= UPPER(jai_constants.tax_type_octroi) then
528: v_octroi_ap := v_octroi_ap + v_tax_amt;
529: else
530: v_others_ap := v_others_ap + v_tax_amt;
531: end if;
571: v_tax_amt := v_tax_amt / c_inv_select_rec.exchange_rate;
572: end if;
573:
574:
575: if v_tax_type in (UPPER(jai_constants.tax_type_exc_additional), UPPER(jai_constants.tax_type_excise) ,UPPER(jai_constants.tax_type_exc_other),
576: UPPER(jai_constants.tax_type_exc_edu_cess), UPPER(jai_constants.tax_type_sh_exc_edu_cess)) then --Added cess and sh cess for bug #16426218
577: v_excise_po := v_excise_po + v_tax_amt;
578: elsif v_tax_type = UPPER(jai_constants. tax_type_cst) then
579: v_cst_po := v_cst_po + v_tax_amt;
572: end if;
573:
574:
575: if v_tax_type in (UPPER(jai_constants.tax_type_exc_additional), UPPER(jai_constants.tax_type_excise) ,UPPER(jai_constants.tax_type_exc_other),
576: UPPER(jai_constants.tax_type_exc_edu_cess), UPPER(jai_constants.tax_type_sh_exc_edu_cess)) then --Added cess and sh cess for bug #16426218
577: v_excise_po := v_excise_po + v_tax_amt;
578: elsif v_tax_type = UPPER(jai_constants. tax_type_cst) then
579: v_cst_po := v_cst_po + v_tax_amt;
580: elsif v_tax_type = UPPER(jai_constants.tax_type_sales) then
574:
575: if v_tax_type in (UPPER(jai_constants.tax_type_exc_additional), UPPER(jai_constants.tax_type_excise) ,UPPER(jai_constants.tax_type_exc_other),
576: UPPER(jai_constants.tax_type_exc_edu_cess), UPPER(jai_constants.tax_type_sh_exc_edu_cess)) then --Added cess and sh cess for bug #16426218
577: v_excise_po := v_excise_po + v_tax_amt;
578: elsif v_tax_type = UPPER(jai_constants. tax_type_cst) then
579: v_cst_po := v_cst_po + v_tax_amt;
580: elsif v_tax_type = UPPER(jai_constants.tax_type_sales) then
581: v_lst_po := v_lst_po + v_tax_amt;
582: elsif v_tax_type = UPPER(jai_constants.tax_type_customs) then
576: UPPER(jai_constants.tax_type_exc_edu_cess), UPPER(jai_constants.tax_type_sh_exc_edu_cess)) then --Added cess and sh cess for bug #16426218
577: v_excise_po := v_excise_po + v_tax_amt;
578: elsif v_tax_type = UPPER(jai_constants. tax_type_cst) then
579: v_cst_po := v_cst_po + v_tax_amt;
580: elsif v_tax_type = UPPER(jai_constants.tax_type_sales) then
581: v_lst_po := v_lst_po + v_tax_amt;
582: elsif v_tax_type = UPPER(jai_constants.tax_type_customs) then
583: v_customs_po := v_customs_po + v_tax_amt;
584: elsif v_tax_type = UPPER(jai_constants.tax_type_cvd) then
578: elsif v_tax_type = UPPER(jai_constants. tax_type_cst) then
579: v_cst_po := v_cst_po + v_tax_amt;
580: elsif v_tax_type = UPPER(jai_constants.tax_type_sales) then
581: v_lst_po := v_lst_po + v_tax_amt;
582: elsif v_tax_type = UPPER(jai_constants.tax_type_customs) then
583: v_customs_po := v_customs_po + v_tax_amt;
584: elsif v_tax_type = UPPER(jai_constants.tax_type_cvd) then
585: v_cvd_po := v_cvd_po + v_tax_amt;
586: -- Date 01-NOV-2006 Bug 5228046 added by SACSETHI
580: elsif v_tax_type = UPPER(jai_constants.tax_type_sales) then
581: v_lst_po := v_lst_po + v_tax_amt;
582: elsif v_tax_type = UPPER(jai_constants.tax_type_customs) then
583: v_customs_po := v_customs_po + v_tax_amt;
584: elsif v_tax_type = UPPER(jai_constants.tax_type_cvd) then
585: v_cvd_po := v_cvd_po + v_tax_amt;
586: -- Date 01-NOV-2006 Bug 5228046 added by SACSETHI
587: -- START BUG 5228046
588: elsif v_tax_type =UPPER( jai_constants.tax_type_add_cvd) then
584: elsif v_tax_type = UPPER(jai_constants.tax_type_cvd) then
585: v_cvd_po := v_cvd_po + v_tax_amt;
586: -- Date 01-NOV-2006 Bug 5228046 added by SACSETHI
587: -- START BUG 5228046
588: elsif v_tax_type =UPPER( jai_constants.tax_type_add_cvd) then
589: v_addcvd_po :=v_addcvd_po + v_tax_amt;
590: -- END BUG 5228046
591: -- Date 24-Nov-2006 Forward porting Bug 5671126 added by Balaji
592: --start
589: v_addcvd_po :=v_addcvd_po + v_tax_amt;
590: -- END BUG 5228046
591: -- Date 24-Nov-2006 Forward porting Bug 5671126 added by Balaji
592: --start
593: elsif v_tax_type = UPPER(jai_constants.tax_type_value_added) then
594: v_vat_po := v_vat_po + v_tax_amt;
595: elsif v_tax_type = UPPER(jai_constants.tax_type_purchase) then
596: v_pur_po := v_pur_po + v_tax_amt;
597: elsif v_tax_type = UPPER(jai_constants.tax_type_turnover) then
591: -- Date 24-Nov-2006 Forward porting Bug 5671126 added by Balaji
592: --start
593: elsif v_tax_type = UPPER(jai_constants.tax_type_value_added) then
594: v_vat_po := v_vat_po + v_tax_amt;
595: elsif v_tax_type = UPPER(jai_constants.tax_type_purchase) then
596: v_pur_po := v_pur_po + v_tax_amt;
597: elsif v_tax_type = UPPER(jai_constants.tax_type_turnover) then
598: v_turnover_po := v_turnover_po + v_tax_amt;
599: elsif v_tax_type = UPPER(jai_constants.tax_type_entry) then
593: elsif v_tax_type = UPPER(jai_constants.tax_type_value_added) then
594: v_vat_po := v_vat_po + v_tax_amt;
595: elsif v_tax_type = UPPER(jai_constants.tax_type_purchase) then
596: v_pur_po := v_pur_po + v_tax_amt;
597: elsif v_tax_type = UPPER(jai_constants.tax_type_turnover) then
598: v_turnover_po := v_turnover_po + v_tax_amt;
599: elsif v_tax_type = UPPER(jai_constants.tax_type_entry) then
600: v_entry_po := v_entry_po + v_tax_amt;
601: elsif v_tax_type = UPPER(jai_constants.tax_type_service) then
595: elsif v_tax_type = UPPER(jai_constants.tax_type_purchase) then
596: v_pur_po := v_pur_po + v_tax_amt;
597: elsif v_tax_type = UPPER(jai_constants.tax_type_turnover) then
598: v_turnover_po := v_turnover_po + v_tax_amt;
599: elsif v_tax_type = UPPER(jai_constants.tax_type_entry) then
600: v_entry_po := v_entry_po + v_tax_amt;
601: elsif v_tax_type = UPPER(jai_constants.tax_type_service) then
602: v_service_po := v_service_po + v_tax_amt;
603: --end
597: elsif v_tax_type = UPPER(jai_constants.tax_type_turnover) then
598: v_turnover_po := v_turnover_po + v_tax_amt;
599: elsif v_tax_type = UPPER(jai_constants.tax_type_entry) then
600: v_entry_po := v_entry_po + v_tax_amt;
601: elsif v_tax_type = UPPER(jai_constants.tax_type_service) then
602: v_service_po := v_service_po + v_tax_amt;
603: --end
604: elsif v_tax_type = UPPER(jai_constants.tax_type_freight) then
605: v_freight_po := v_freight_po + v_tax_amt;
600: v_entry_po := v_entry_po + v_tax_amt;
601: elsif v_tax_type = UPPER(jai_constants.tax_type_service) then
602: v_service_po := v_service_po + v_tax_amt;
603: --end
604: elsif v_tax_type = UPPER(jai_constants.tax_type_freight) then
605: v_freight_po := v_freight_po + v_tax_amt;
606: elsif v_tax_type = UPPER(jai_constants.tax_type_octroi) then
607: v_octroi_po := v_octroi_po + v_tax_amt;
608: else
602: v_service_po := v_service_po + v_tax_amt;
603: --end
604: elsif v_tax_type = UPPER(jai_constants.tax_type_freight) then
605: v_freight_po := v_freight_po + v_tax_amt;
606: elsif v_tax_type = UPPER(jai_constants.tax_type_octroi) then
607: v_octroi_po := v_octroi_po + v_tax_amt;
608: else
609: v_others_po := v_others_po + v_tax_amt;
610: end if;
638: if c_inv_select_rec.invoice_currency_code <> c_get_tax_from_po_rec.currency then
639: v_tax_amt := v_tax_amt / c_inv_select_rec.exchange_rate;
640: end if;
641:
642: if v_tax_type in (UPPER(jai_constants.tax_type_exc_additional) ,UPPER( jai_constants.tax_type_excise) ,UPPER(jai_constants.tax_type_exc_other),
643: UPPER(jai_constants.tax_type_exc_edu_cess), UPPER(jai_constants.tax_type_sh_exc_edu_cess)) then --Added cess and sh cess for bug #16426218
644: v_excise_po := v_excise_po + v_tax_amt;
645: elsif v_tax_type = UPPER(jai_constants.tax_type_cst) then
646: v_cst_po := v_cst_po + v_tax_amt;
639: v_tax_amt := v_tax_amt / c_inv_select_rec.exchange_rate;
640: end if;
641:
642: if v_tax_type in (UPPER(jai_constants.tax_type_exc_additional) ,UPPER( jai_constants.tax_type_excise) ,UPPER(jai_constants.tax_type_exc_other),
643: UPPER(jai_constants.tax_type_exc_edu_cess), UPPER(jai_constants.tax_type_sh_exc_edu_cess)) then --Added cess and sh cess for bug #16426218
644: v_excise_po := v_excise_po + v_tax_amt;
645: elsif v_tax_type = UPPER(jai_constants.tax_type_cst) then
646: v_cst_po := v_cst_po + v_tax_amt;
647: elsif v_tax_type =UPPER(jai_constants.tax_type_sales) then
641:
642: if v_tax_type in (UPPER(jai_constants.tax_type_exc_additional) ,UPPER( jai_constants.tax_type_excise) ,UPPER(jai_constants.tax_type_exc_other),
643: UPPER(jai_constants.tax_type_exc_edu_cess), UPPER(jai_constants.tax_type_sh_exc_edu_cess)) then --Added cess and sh cess for bug #16426218
644: v_excise_po := v_excise_po + v_tax_amt;
645: elsif v_tax_type = UPPER(jai_constants.tax_type_cst) then
646: v_cst_po := v_cst_po + v_tax_amt;
647: elsif v_tax_type =UPPER(jai_constants.tax_type_sales) then
648: v_lst_po := v_lst_po + v_tax_amt;
649: elsif v_tax_type = UPPER(jai_constants.tax_type_customs) then
643: UPPER(jai_constants.tax_type_exc_edu_cess), UPPER(jai_constants.tax_type_sh_exc_edu_cess)) then --Added cess and sh cess for bug #16426218
644: v_excise_po := v_excise_po + v_tax_amt;
645: elsif v_tax_type = UPPER(jai_constants.tax_type_cst) then
646: v_cst_po := v_cst_po + v_tax_amt;
647: elsif v_tax_type =UPPER(jai_constants.tax_type_sales) then
648: v_lst_po := v_lst_po + v_tax_amt;
649: elsif v_tax_type = UPPER(jai_constants.tax_type_customs) then
650: v_customs_po := v_customs_po + v_tax_amt;
651: elsif v_tax_type = UPPER(jai_constants.tax_type_cvd) then
645: elsif v_tax_type = UPPER(jai_constants.tax_type_cst) then
646: v_cst_po := v_cst_po + v_tax_amt;
647: elsif v_tax_type =UPPER(jai_constants.tax_type_sales) then
648: v_lst_po := v_lst_po + v_tax_amt;
649: elsif v_tax_type = UPPER(jai_constants.tax_type_customs) then
650: v_customs_po := v_customs_po + v_tax_amt;
651: elsif v_tax_type = UPPER(jai_constants.tax_type_cvd) then
652: v_cvd_po := v_cvd_po + v_tax_amt;
653: elsif v_tax_type= UPPER(jai_constants.tax_type_add_cvd) then
647: elsif v_tax_type =UPPER(jai_constants.tax_type_sales) then
648: v_lst_po := v_lst_po + v_tax_amt;
649: elsif v_tax_type = UPPER(jai_constants.tax_type_customs) then
650: v_customs_po := v_customs_po + v_tax_amt;
651: elsif v_tax_type = UPPER(jai_constants.tax_type_cvd) then
652: v_cvd_po := v_cvd_po + v_tax_amt;
653: elsif v_tax_type= UPPER(jai_constants.tax_type_add_cvd) then
654: v_addcvd_po := v_addcvd_po + v_tax_amt ;
655: elsif v_tax_type = UPPER(jai_constants.tax_type_freight) then
649: elsif v_tax_type = UPPER(jai_constants.tax_type_customs) then
650: v_customs_po := v_customs_po + v_tax_amt;
651: elsif v_tax_type = UPPER(jai_constants.tax_type_cvd) then
652: v_cvd_po := v_cvd_po + v_tax_amt;
653: elsif v_tax_type= UPPER(jai_constants.tax_type_add_cvd) then
654: v_addcvd_po := v_addcvd_po + v_tax_amt ;
655: elsif v_tax_type = UPPER(jai_constants.tax_type_freight) then
656: v_freight_po := v_freight_po + v_tax_amt;
657: elsif v_tax_type = UPPER(jai_constants.tax_type_octroi) then
651: elsif v_tax_type = UPPER(jai_constants.tax_type_cvd) then
652: v_cvd_po := v_cvd_po + v_tax_amt;
653: elsif v_tax_type= UPPER(jai_constants.tax_type_add_cvd) then
654: v_addcvd_po := v_addcvd_po + v_tax_amt ;
655: elsif v_tax_type = UPPER(jai_constants.tax_type_freight) then
656: v_freight_po := v_freight_po + v_tax_amt;
657: elsif v_tax_type = UPPER(jai_constants.tax_type_octroi) then
658: v_octroi_po := v_octroi_po + v_tax_amt;
659:
653: elsif v_tax_type= UPPER(jai_constants.tax_type_add_cvd) then
654: v_addcvd_po := v_addcvd_po + v_tax_amt ;
655: elsif v_tax_type = UPPER(jai_constants.tax_type_freight) then
656: v_freight_po := v_freight_po + v_tax_amt;
657: elsif v_tax_type = UPPER(jai_constants.tax_type_octroi) then
658: v_octroi_po := v_octroi_po + v_tax_amt;
659:
660: -- Date 24-Nov-2006 Forward porting Bug 5671126 added by Balaji
661: --start
659:
660: -- Date 24-Nov-2006 Forward porting Bug 5671126 added by Balaji
661: --start
662:
663: elsif v_tax_type = upper(jai_constants.tax_type_value_added) then
664: v_vat_po := v_vat_po + v_tax_amt;
665: elsif v_tax_type= upper(jai_constants.tax_type_purchase) then
666: v_pur_po := v_pur_po + v_tax_amt;
667: elsif v_tax_type = upper(jai_constants.tax_type_turnover) then
661: --start
662:
663: elsif v_tax_type = upper(jai_constants.tax_type_value_added) then
664: v_vat_po := v_vat_po + v_tax_amt;
665: elsif v_tax_type= upper(jai_constants.tax_type_purchase) then
666: v_pur_po := v_pur_po + v_tax_amt;
667: elsif v_tax_type = upper(jai_constants.tax_type_turnover) then
668: v_turnover_po := v_turnover_po + v_tax_amt;
669: elsif v_tax_type = upper(jai_constants.tax_type_entry) then
663: elsif v_tax_type = upper(jai_constants.tax_type_value_added) then
664: v_vat_po := v_vat_po + v_tax_amt;
665: elsif v_tax_type= upper(jai_constants.tax_type_purchase) then
666: v_pur_po := v_pur_po + v_tax_amt;
667: elsif v_tax_type = upper(jai_constants.tax_type_turnover) then
668: v_turnover_po := v_turnover_po + v_tax_amt;
669: elsif v_tax_type = upper(jai_constants.tax_type_entry) then
670: v_entry_po := v_entry_po + v_tax_amt;
671: elsif v_tax_type = upper(jai_constants.tax_type_service) then
665: elsif v_tax_type= upper(jai_constants.tax_type_purchase) then
666: v_pur_po := v_pur_po + v_tax_amt;
667: elsif v_tax_type = upper(jai_constants.tax_type_turnover) then
668: v_turnover_po := v_turnover_po + v_tax_amt;
669: elsif v_tax_type = upper(jai_constants.tax_type_entry) then
670: v_entry_po := v_entry_po + v_tax_amt;
671: elsif v_tax_type = upper(jai_constants.tax_type_service) then
672: v_service_po := v_service_po + v_tax_amt;
673: --end
667: elsif v_tax_type = upper(jai_constants.tax_type_turnover) then
668: v_turnover_po := v_turnover_po + v_tax_amt;
669: elsif v_tax_type = upper(jai_constants.tax_type_entry) then
670: v_entry_po := v_entry_po + v_tax_amt;
671: elsif v_tax_type = upper(jai_constants.tax_type_service) then
672: v_service_po := v_service_po + v_tax_amt;
673: --end
674: else
675: v_others_po := v_others_po + v_tax_amt;