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_RCV_LINE_TAXES

Line 2057: Cursor c_excise_tax_rate(cp_shipment_header_id JAI_RCV_LINE_TAXES.shipment_header_id%TYPE,

2053: ln_exc_edu_cess NUMBER; /*vkaranam for bug 5989740*/
2054: ln_sh_exc_edu_cess NUMBER; /*vkaranam for bug 5989740*/
2055:
2056: /* added, vumaasha for Bug 4689713 */
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

Line 2058: cp_shipment_line_id JAI_RCV_LINE_TAXES.shipment_line_id%TYPE ) IS

2054: ln_sh_exc_edu_cess NUMBER; /*vkaranam for bug 5989740*/
2055:
2056: /* added, vumaasha for Bug 4689713 */
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

Line 2060: from JAI_RCV_LINE_TAXES jrtl ,

2056: /* added, vumaasha for Bug 4689713 */
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

Line 2533: FROM JAI_RCV_LINE_TAXES

2529: ANd transaction_source_num = cp_transaction_id;
2530:
2531: CURSOR c_tax_rate(cp_shipment_line_id IN NUMBER) IS
2532: SELECT tax_rate
2533: FROM JAI_RCV_LINE_TAXES
2534: WHERE shipment_line_id = cp_shipment_line_id
2535: AND tax_type IN (jai_constants.tax_type_excise,
2536: jai_constants.tax_type_exc_additional,
2537: jai_constants.tax_type_exc_other,

Line 4922: FROM JAI_RCV_LINE_TAXES

4918: jai_constants.tax_type_exc_edu_cess,1,
4919: jai_constants.tax_type_cvd_edu_cess,1,jai_constants.tax_type_sh_exc_edu_cess,1,
4920: jai_constants.tax_type_sh_cvd_edu_cess,1, 0) --kunkumar for bugno5989740 -- Vijay Shankar for Bug#3940588 EDU CESS
4921: ) excise_cnt
4922: FROM JAI_RCV_LINE_TAXES
4923: WHERE shipment_line_id = cp_shipment_line_id
4924: AND tax_type not in (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery);
4925:
4926: r_taxes c_taxes%ROWTYPE;

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 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 6786: FROM jai_rcv_line_taxes jrt,rcv_transactions rt,

6782: )
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