DBA Data[Home] [Help]

APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on JAI_CMN_TAXES_ALL

Line 693: JAI_CMN_TAXES_ALL jtc

689: * 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)
690: ) tax_amount,
691: jtc.tax_account_id
692: FROM JAI_RCV_LINE_TAXES rtl,
693: JAI_CMN_TAXES_ALL jtc
694: WHERE jtc.tax_id = rtl.tax_id
695: AND shipment_line_id = p_shipment_line_id
696: AND upper(rtl.tax_type) NOT IN ( 'EXCISE', 'ADDL. EXCISE',
697: 'OTHER EXCISE', 'CVD','TDS', 'MODVAT RECOVERY',

Line 900: JAI_CMN_TAXES_ALL jtc

896: nvl(rtl.currency, 'INR') currency,
897: nvl(jtc.mod_cr_percentage, 0) mod_cr_percentage
898: FROM
899: JAI_RCV_LINE_TAXES rtl,
900: JAI_CMN_TAXES_ALL jtc
901: WHERE
902: shipment_line_id = p_shipment_line_id
903: AND jtc.tax_id = rtl.tax_id
904: