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 4844: FROM JAI_RCV_LINE_TAXES rtl, JAI_CMN_TAXES_ALL jtc

4840: nvl(rtl.modvat_flag, 'N') modvat_flag ,
4841: nvl(rtl.currency, jai_rcv_trx_processing_pkg.gv_func_curr) currency ,
4842: nvl(decode(p_breakup_type, 'RG23D', 100, jtc.mod_cr_percentage), 0) mod_cr_percentage,
4843: nvl(jtc.rounding_factor, 0) rnd
4844: FROM JAI_RCV_LINE_TAXES rtl, JAI_CMN_TAXES_ALL jtc
4845: WHERE rtl.shipment_line_id = p_shipment_line_id
4846: AND jtc.tax_id = rtl.tax_id)
4847: LOOP
4848:

Line 5599: lv_stform_type JAI_CMN_TAXES_ALL.stform_type%type ;

5595: select receipt_excise_rate, rtv_excise_rate, excise_basis_amt
5596: from jai_rcv_rtv_batch_trxs
5597: where transaction_id = cp_transaction_id;
5598:
5599: lv_stform_type JAI_CMN_TAXES_ALL.stform_type%type ;
5600:
5601: cursor c_excise_cess_rate(cp_shipment_line_id in number) is
5602: select a.tax_rate, b.tax_account_id, a.tax_id
5603: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b

Line 5603: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b

5599: lv_stform_type JAI_CMN_TAXES_ALL.stform_type%type ;
5600:
5601: cursor c_excise_cess_rate(cp_shipment_line_id in number) is
5602: select a.tax_rate, b.tax_account_id, a.tax_id
5603: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
5604: where a.shipment_line_id = cp_shipment_line_id
5605: and a.tax_id = b.tax_id
5606: and ( a.tax_type = jai_constants.tax_type_exc_edu_cess
5607: -- following is to take care of Initial solution(Year2004) for Excise Cess func.

Line 5615: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b

5611:
5612: --added by csahoo for bug#6078460
5613: cursor c_excise_sh_cess_rate(cp_shipment_line_id in number) is
5614: select a.tax_rate, b.tax_account_id, a.tax_id
5615: from JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
5616: where a.shipment_line_id = cp_shipment_line_id
5617: and a.tax_id = b.tax_id
5618: and ( a.tax_type = jai_constants.tax_type_sh_exc_edu_cess
5619: -- following is to take care of Initial solution(Year2004) for Excise sh Cess func.

Line 5654: ln_excise_cess_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE;

5650:
5651: r_diff_tax jai_rcv_excise_processing_pkg.TAX_BREAKUP;
5652: r_rtv_dtls c_rtv_dtls%ROWTYPE;
5653:
5654: ln_excise_cess_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE;
5655: ln_excise_cess_rate NUMBER;
5656: ln_excise_cess_accnt_id gl_code_combinations.code_combination_id%TYPE;
5657: --added by csahoo for bug#6078460, start
5658: ln_excise_sh_cess_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE;

Line 5658: ln_excise_sh_cess_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE;

5654: ln_excise_cess_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE;
5655: ln_excise_cess_rate NUMBER;
5656: ln_excise_cess_accnt_id gl_code_combinations.code_combination_id%TYPE;
5657: --added by csahoo for bug#6078460, start
5658: ln_excise_sh_cess_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE;
5659: ln_excise_sh_cess_rate NUMBER;
5660: ln_excise_sh_cess_accnt_id gl_code_combinations.code_combination_id%TYPE;
5661: --added by csahoo for bug#6078460, end
5662: lv_cenvat_register_type VARCHAR2(30);