[Home] [Help]
633: SELECT nvl(sum(tax_amount),0) ,
634: nvl(sum(base_tax_amount),0),
635: nvl(sum(func_tax_amount),0)
636: FROM
637: JAI_CMN_MATCH_TAXES
638: WHERE
639: ref_line_id = v_delivery_detail_id AND
640: receipt_id IS NOT NULL AND
641: tax_id = p_tax_id;
643: CURSOR ed_cur (p_tax_type VARCHAR2)IS
644: SELECT
645: nvl(sum(a.func_tax_amount),0)
646: FROM
647: JAI_CMN_MATCH_TAXES a,
648: JAI_CMN_TAXES_ALL b
649: WHERE
650: a.tax_id = b.tax_id AND
651: b.tax_type = p_tax_type AND
1052: OPEN uom_code;
1053: FETCH uom_code INTO v_order_quantity_uom;
1054: CLOSE uom_code;
1055:
1056: /*As the tax amount, base_tax_amount and func_tax_amount would be present in table JAI_CMN_MATCH_TAXES
1057: only when match receipt functionality has been done .
1058: Now in order to check that the match receipts functionality has been performed the following check has been added in additions
1059: to the other three checks (of organization being a trading organization, Item being tradable and excisable ):-
1060: The order attached to the bond register is one of 'Trading Domestic With Excise' or 'Export With Excise'
1426: FETCH get_item_dtls INTO v_excise_flag,v_item_class;
1427: CLOSE get_item_dtls;
1428:
1429: /*
1430: As the tax amount, base_tax_amount and func_tax_amount would be present in table JAI_CMN_MATCH_TAXES
1431: only when match receipt functionality has been done .
1432: Now in order to check that the match receipts functionality has been performed the following check has been added in additions
1433: to the other three checks (of organization being a trading organization, Item being tradable and excisable ):-
1434: The order attached to the bond register is one of 'Trading Domestic With Excise' or 'Export With Excise'