DBA Data[Home] [Help]

APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on JAI_CMN_TAXES_ALL

Line 780: JAI_CMN_TAXES_ALL jtc

776: * decode(nvl(rtl.currency, jai_rcv_trx_processing_pkg.gv_func_curr), jai_rcv_trx_processing_pkg.gv_func_curr, 1, p_currency_conversion_rate)
777: ) tax_amount,
778: jtc.tax_account_id
779: FROM JAI_RCV_LINE_TAXES rtl,
780: JAI_CMN_TAXES_ALL jtc
781: WHERE jtc.tax_id = rtl.tax_id
782: AND shipment_line_id = p_shipment_line_id
783: AND upper(rtl.tax_type) NOT IN ( 'EXCISE', 'ADDL. EXCISE',
784: 'OTHER EXCISE', 'CVD','TDS', 'MODVAT RECOVERY',

Line 997: JAI_CMN_TAXES_ALL jtc

993: nvl(jtc.mod_cr_percentage, 0) mod_cr_percentage,
994: nvl(jtc.rounding_factor, 0) rounding_factor --Added for bug #13494816
995: FROM
996: JAI_RCV_LINE_TAXES rtl,
997: JAI_CMN_TAXES_ALL jtc
998: WHERE
999: shipment_line_id = p_shipment_line_id
1000: AND jtc.tax_id = rtl.tax_id
1001: