APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_CMN_TAXES_ALL

Line 4178: select 1 from jai_rcv_line_taxes jrlt, jai_cmn_taxes_all jcta

4174: or less than 100*/
4175: Cursor c_check_non_recover_taxes (p_shipment_line_id number) is /*Added by nprashar for bug # 9767315*/
4176: select 1 from dual
4177: Where Exists (
4178: select 1 from jai_rcv_line_taxes jrlt, jai_cmn_taxes_all jcta
4179: where jrlt.tax_id = jcta.tax_id
4180: and jrlt.shipment_line_id = p_shipment_line_id
4181: and (jrlt.modvat_flag = 'N' or (jrlt.modvat_flag='Y' and nvl(jcta.mod_cr_percentage,0)<100)));
4182:

Line 5347: FROM JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b

5343: ) manufacturing_cenvat,
5344: sum(
5345: nvl(a.tax_amount, 0) * decode(a.currency, jai_general_pkg.INDIAN_CURRENCY, 1, cp_curr_conv_rate)
5346: ) trading_cenvat
5347: FROM JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
5348: WHERE shipment_line_id = cp_shipment_line_id
5349: AND a.tax_id = b.tax_id
5350: AND upper(a.tax_type) IN ( 'EXCISE',
5351: 'ADDL. EXCISE',