eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on JAI_CMN_TAXES_ALL

Line 2061: JAI_CMN_TAXES_ALL jtc

2057: Cursor c_excise_tax_rate(cp_shipment_header_id JAI_RCV_LINE_TAXES.shipment_header_id%TYPE,
2058: cp_shipment_line_id JAI_RCV_LINE_TAXES.shipment_line_id%TYPE ) IS
2059: select nvl(sum(jrtl.tax_rate),0) , count(jrtl.tax_rate)
2060: from JAI_RCV_LINE_TAXES jrtl ,
2061: JAI_CMN_TAXES_ALL jtc
2062: where jrtl.tax_id = jtc.tax_id
2063: and jrtl.shipment_header_id = cp_shipment_header_id
2064: and jrtl.shipment_line_id = cp_shipment_line_id
2065: AND UPPER(jtc.tax_type) = 'EXCISE' ;

Line 2067: ln_total_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;

2063: and jrtl.shipment_header_id = cp_shipment_header_id
2064: and jrtl.shipment_line_id = cp_shipment_line_id
2065: AND UPPER(jtc.tax_type) = 'EXCISE' ;
2066:
2067: ln_total_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
2068: ln_number_of_Taxes NUMBER;
2069:
2070: /* ended, vumaasha for Bug 4689713 */
2071:

Line 5238: FROM JAI_RCV_LINE_TAXES rtl, JAI_CMN_TAXES_ALL jtc

5234: nvl(rtl.currency, jai_rcv_trx_processing_pkg.gv_func_curr) currency ,
5235: nvl(decode(p_breakup_type, 'RG23D', 100, jtc.mod_cr_percentage), 0) mod_cr_percentage,
5236: nvl(jtc.rounding_factor, 0) rnd,
5237: nvl(jtc.inclusive_tax_flag,'N') INCLUSIVE_TAX_FLAG --12817175
5238: FROM JAI_RCV_LINE_TAXES rtl, JAI_CMN_TAXES_ALL jtc
5239: WHERE rtl.shipment_line_id = p_shipment_line_id
5240: AND jtc.tax_id = rtl.tax_id)
5241: LOOP
5242:

Line 6185: lv_stform_type JAI_CMN_TAXES_ALL.stform_type%type ;

6181: select receipt_excise_rate, rtv_excise_rate, excise_basis_amt
6182: from jai_rcv_rtv_batch_trxs
6183: where transaction_id = cp_transaction_id;
6184:
6185: lv_stform_type JAI_CMN_TAXES_ALL.stform_type%type ;
6186:
6187: cursor c_excise_cess_rate(cp_shipment_line_id in number) is
6188: select a.tax_rate, b.tax_account_id, a.tax_id
6189: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b

Line 6189: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b

6185: lv_stform_type JAI_CMN_TAXES_ALL.stform_type%type ;
6186:
6187: cursor c_excise_cess_rate(cp_shipment_line_id in number) is
6188: select a.tax_rate, b.tax_account_id, a.tax_id
6189: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
6190: where a.shipment_line_id = cp_shipment_line_id
6191: and a.tax_id = b.tax_id
6192: and ( a.tax_type = jai_constants.tax_type_exc_edu_cess
6193: -- following is to take care of Initial solution(Year2004) for Excise Cess func.

Line 6201: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b

6197:
6198: --added by csahoo for bug#6078460
6199: cursor c_excise_sh_cess_rate(cp_shipment_line_id in number) is
6200: select a.tax_rate, b.tax_account_id, a.tax_id
6201: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
6202: where a.shipment_line_id = cp_shipment_line_id
6203: and a.tax_id = b.tax_id
6204: and ( a.tax_type = jai_constants.tax_type_sh_exc_edu_cess
6205: -- following is to take care of Initial solution(Year2004) for Excise sh Cess func.

Line 6240: ln_excise_cess_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE;

6236:
6237: r_diff_tax jai_rcv_excise_processing_pkg.TAX_BREAKUP;
6238: r_rtv_dtls c_rtv_dtls%ROWTYPE;
6239:
6240: ln_excise_cess_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE;
6241: ln_excise_cess_rate NUMBER;
6242: ln_excise_cess_accnt_id gl_code_combinations.code_combination_id%TYPE;
6243: --added by csahoo for bug#6078460, start
6244: ln_excise_sh_cess_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE;

Line 6244: ln_excise_sh_cess_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE;

6240: ln_excise_cess_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE;
6241: ln_excise_cess_rate NUMBER;
6242: ln_excise_cess_accnt_id gl_code_combinations.code_combination_id%TYPE;
6243: --added by csahoo for bug#6078460, start
6244: ln_excise_sh_cess_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE;
6245: ln_excise_sh_cess_rate NUMBER;
6246: ln_excise_sh_cess_accnt_id gl_code_combinations.code_combination_id%TYPE;
6247: --added by csahoo for bug#6078460, end
6248: lv_cenvat_register_type VARCHAR2(30);

Line 6787: jai_cmn_taxes_all jt

6783: IS
6784: CURSOR c_get_tax_rounding_factor(cp_transaction_id NUMBER) IS
6785: SELECT jt.tax_id,jt.tax_name,nvl(jt.ROUNDING_FACTOR,0) rf,jt.tax_type
6786: FROM jai_rcv_line_taxes jrt,rcv_transactions rt,
6787: jai_cmn_taxes_all jt
6788: WHERE jrt.shipment_line_id = rt.shipment_line_id
6789: AND jrt.shipment_header_id = rt.shipment_header_id
6790: AND jt.tax_id = jrt.tax_id
6791: AND rt.transaction_id=cp_transaction_id;