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_AP_DTC_GENERATION_PKG dependencies on JAI_CMN_TAXES_ALL

Line 105: from jai_cmn_taxes_all

101: and invoice_distribution_id = p_invoice_distribution_id;
102:
103: cursor c_get_tax_rate(p_tax_id number) is
104: select tax_rate
105: from jai_cmn_taxes_all
106: where tax_id = p_tax_id;
107:
108: ln_tax_id number;
109: ln_tax_rate number;

Line 998: from jai_cmn_taxes_all

994: and invoice_distribution_id = p_invoice_distribution_id;
995:
996: cursor c_get_tax_rate(p_tax_id number) is
997: select tax_rate
998: from jai_cmn_taxes_all
999: where tax_id = p_tax_id;
1000:
1001: ln_tax_id number;
1002: ln_tax_rate number;

Line 2183: from jai_cmn_taxes_all

2179:
2180: cursor get_tax_rate(cn_tax_id number)
2181: is
2182: select tax_rate
2183: from jai_cmn_taxes_all
2184: where tax_id = cn_tax_id;
2185:
2186: rec_challan get_challan_info%rowtype;
2187:

Line 2443: from JAI_CMN_TAXES_ALL

2439: end_date,
2440: sysdate,
2441: 'Tax : ' || tax_name || ' is end dated as on ' || to_char(end_date, 'dd-mon-yyyy') ||
2442: '. Setup needs modification.' tax_end_dated_message
2443: from JAI_CMN_TAXES_ALL
2444: where tax_id = p_tax_id;
2445: /*Bug 5751783 - Selected non-rounded value for calculation*/
2446: cursor c_for_each_tds_section(p_invoice_id number, p_exchange_rate number,p_section_type jai_ap_tds_inv_taxes.section_type%type, p_prepay_amt number) is--rchandan for bug#4428980 --add by xiao for bug#6596019
2447: select actual_section_code, (sum(amount*p_exchange_rate)-p_prepay_amt) invoice_amount, sum(calc_tax_amount) section_amount,

Line 2694: jai_cmn_taxes_all jitc

2690: jattt.tax_id tax_id,
2691: (jitc.tax_rate-(nvl(jitc.surcharge_rate,0) + nvl(jitc.cess_rate,0) + nvl(jitc.sh_cess_rate,0))) tax_rate_orig
2692: from jai_ap_tds_thhold_slabs jatts,
2693: jai_ap_tds_thhold_taxes jattt,
2694: jai_cmn_taxes_all jitc
2695: where jatts.threshold_slab_id = jattt.threshold_slab_id
2696: and jattt.tax_id = jitc.tax_id
2697: and jatts.threshold_slab_id = p_threshold_slab_id;
2698:

Line 2717: from jai_cmn_taxes_all jitc, jai_ap_tds_inv_taxes jatit

2713: CURSOR c_check_valid_tax(p_invoice_id number)
2714: IS
2715: -- select jitc.section_code section_code --Commented by ChongLei for DTC ER 2011/12/29
2716: select jatit.actual_section_code section_code --Added by ChongLei for DTC ER 2011/12/29
2717: from jai_cmn_taxes_all jitc, jai_ap_tds_inv_taxes jatit
2718: where jitc.tax_id = jatit.actual_tax_id
2719: and jatit.section_type = 'TDS_SECTION'
2720: and jatit.invoice_id = p_invoice_id
2721: and jatit.actual_tax_id is not null

Line 2852: FROM JAI_CMN_TAXES_ALL TAX,

2848: CATE.PRECEDENCE_7,
2849: CATE.PRECEDENCE_8,
2850: CATE.PRECEDENCE_9,
2851: CATE.PRECEDENCE_10
2852: FROM JAI_CMN_TAXES_ALL TAX,
2853: JAI_CMN_TAX_CTG_LINES CATE
2854: WHERE CATE.TAX_CATEGORY_ID = cn_tax_category_id
2855: AND TAX.TAX_ID = CATE.TAX_ID;
2856:

Line 5177: from jai_cmn_taxes_all

5173:
5174: cursor get_tax_info(cn_tax_id number)
5175: is
5176: select tax_type,section_type
5177: from jai_cmn_taxes_all
5178: where tax_id = cn_tax_id;
5179:
5180: lv_tax_type jai_cmn_taxes_all.tax_type%type;
5181: lv_section_type_tax jai_cmn_taxes_all.section_type%type;

Line 5180: lv_tax_type jai_cmn_taxes_all.tax_type%type;

5176: select tax_type,section_type
5177: from jai_cmn_taxes_all
5178: where tax_id = cn_tax_id;
5179:
5180: lv_tax_type jai_cmn_taxes_all.tax_type%type;
5181: lv_section_type_tax jai_cmn_taxes_all.section_type%type;
5182: ln_rounding_factor number;
5183: ln_tax_rounding_factor number; -- Added by Chong for bug#15939571 20121210
5184: ln_tax_amount number;

Line 5181: lv_section_type_tax jai_cmn_taxes_all.section_type%type;

5177: from jai_cmn_taxes_all
5178: where tax_id = cn_tax_id;
5179:
5180: lv_tax_type jai_cmn_taxes_all.tax_type%type;
5181: lv_section_type_tax jai_cmn_taxes_all.section_type%type;
5182: ln_rounding_factor number;
5183: ln_tax_rounding_factor number; -- Added by Chong for bug#15939571 20121210
5184: ln_tax_amount number;
5185:

Line 5212: JAI_CMN_TAXES_ALL tax

5208: cursor chk_surcharge_tax(cn_category_id number)
5209: is
5210: select tax.tax_id,tax.tax_rate, tax.section_code
5211: from JAI_CMN_TAX_CTG_LINES cat,
5212: JAI_CMN_TAXES_ALL tax
5213: where cat.tax_id = tax.tax_id
5214: and tax.tax_type in ('TDS_SURCHARGE')
5215: and cat.tax_category_id = cn_category_id;
5216:

Line 5249: ,jai_cmn_taxes_all jcta

5245: /*Commented out by Chong for bug#15976304 20121212 Start
5246: AND NOT EXISTS(
5247: SELECT 1
5248: FROM JAI_AP_TDS_INV_TAXES jatit
5249: ,jai_cmn_taxes_all jcta
5250: WHERE jatit.invoice_id = jattt.invoice_id
5251: AND jcta.tax_id = jatit.actual_tax_id
5252: AND jcta.tax_type = 'TDS_SURCHARGE'
5253: )

Line 5260: ,jai_cmn_taxes_all jcta

5256: ------------------------------------------------
5257: AND NOT EXISTS(
5258: SELECT 1
5259: FROM JAI_CMN_TAX_CTG_LINES jctcl
5260: ,jai_cmn_taxes_all jcta
5261: WHERE jctcl.tax_category_id = jattt.tax_category_id
5262: AND jctcl.tax_id = jcta.tax_id
5263: AND jcta.tax_type = 'TDS_SURCHARGE'
5264: )

Line 5904: from JAI_CMN_TAXES_ALL

5900: stform_type,
5901: tax_account_id,
5902: section_type,
5903: tax_type
5904: from JAI_CMN_TAXES_ALL
5905: where tax_id = pn_tax_id;
5906:
5907:
5908: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

Line 6823: from JAI_CMN_TAXES_ALL

6819: tax_rate,
6820: stform_type,
6821: tax_account_id,
6822: section_type
6823: from JAI_CMN_TAXES_ALL
6824: where tax_id = pn_tax_id;
6825:
6826:
6827: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

Line 6933: from jai_cmn_taxes_all

6929: and tax_category_id = pn_tax_category_id
6930: and actual_tax_id in
6931: (
6932: select tax_id
6933: from jai_cmn_taxes_all
6934: where tax_type = cv_tax_type
6935: );
6936:
6937:

Line 6991: from jai_cmn_taxes_all

6987: and tax_category_id = pn_tax_category_id
6988: and actual_tax_id in
6989: (
6990: select tax_id
6991: from jai_cmn_taxes_all
6992: where tax_type = cv_tax_type
6993: );
6994:
6995:

Line 7035: from jai_cmn_taxes_all

7031: ---------------------------------------------
7032: cursor get_tax_rate(cv_taxs_type varchar2)
7033: is
7034: select tax_rate
7035: from jai_cmn_taxes_all
7036: where tax_id in
7037: (
7038: select actual_tax_id
7039: from jai_ap_tds_inv_taxes

Line 7407: from jai_cmn_taxes_all

7403:
7404: for rec_tax in (
7405:
7406: /*select distinct tax_type
7407: from jai_cmn_taxes_all
7408: where tax_id in
7409: (*/
7410: select distinct tax_type
7411: from (

Line 10127: ,jai_cmn_taxes_all jcta

10123: AND jattt.threshold_grp_id = p_threshold_grp_id
10124: AND EXISTS(
10125: SELECT 1
10126: FROM JAI_AP_TDS_INV_TAXES jatit
10127: ,jai_cmn_taxes_all jcta
10128: WHERE jatit.invoice_id = jattt.invoice_id
10129: AND jcta.tax_id = jatit.actual_tax_id
10130: AND jcta.tax_type = 'TDS_SURCHARGE'
10131: )

Line 10154: ,jai_cmn_taxes_all jcta

10150: AND jattt.threshold_grp_id = p_threshold_grp_id
10151: AND EXISTS(
10152: SELECT 1
10153: FROM JAI_AP_TDS_INV_TAXES jatit
10154: ,jai_cmn_taxes_all jcta
10155: WHERE jatit.invoice_id = jattt.invoice_id
10156: AND jcta.tax_id = jatit.actual_tax_id
10157: AND jcta.tax_type = 'TDS_SURCHARGE'
10158: )

Line 10334: --cursor c_ja_in_tax_codes (cn_tax_account jai_cmn_taxes_all.tax_account_id%type) is

10330: from po_vendors
10331: where vendor_id = cp_vendor_id;
10332:
10333: --Get tax info by tax_account_id
10334: --cursor c_ja_in_tax_codes (cn_tax_account jai_cmn_taxes_all.tax_account_id%type) is
10335: cursor c_ja_in_tax_codes (cn_tax_id jai_cmn_taxes_all.tax_id%type) is --Change to tax_id by Chong for bug#16414088 20130320
10336: select jcta.section_code,
10337: jcta.vendor_id,
10338: jcta.vendor_site_id,

Line 10335: cursor c_ja_in_tax_codes (cn_tax_id jai_cmn_taxes_all.tax_id%type) is --Change to tax_id by Chong for bug#16414088 20130320

10331: where vendor_id = cp_vendor_id;
10332:
10333: --Get tax info by tax_account_id
10334: --cursor c_ja_in_tax_codes (cn_tax_account jai_cmn_taxes_all.tax_account_id%type) is
10335: cursor c_ja_in_tax_codes (cn_tax_id jai_cmn_taxes_all.tax_id%type) is --Change to tax_id by Chong for bug#16414088 20130320
10336: select jcta.section_code,
10337: jcta.vendor_id,
10338: jcta.vendor_site_id,
10339: jcta.tax_rate,

Line 10345: from jai_cmn_taxes_all jcta

10341: jcta.stform_type,
10342: jcta.tax_account_id,
10343: jcta.tax_id, --Added tax_id by Chong for bug#16414088 20130320
10344: jcta.section_type
10345: from jai_cmn_taxes_all jcta
10346: ,jai_ap_tds_inv_taxes jatit
10347: ,jai_ap_tds_thhold_trxs jattt
10348: where jatit.actual_tax_id = jcta.tax_id
10349: and jatit.threshold_trx_id = jattt.threshold_trx_id

Line 10453: --cursor get_amt_for_tax_account(cn_tax_account jai_cmn_taxes_all.tax_account_id%type)

10449: and jattt.tds_rollbacked is null
10450: and jatit.threshold_slab_id_single is null;
10451:
10452: --get amount for a tax acount
10453: --cursor get_amt_for_tax_account(cn_tax_account jai_cmn_taxes_all.tax_account_id%type)
10454: cursor get_amt_for_tax_account(cn_tax_id jai_cmn_taxes_all.tax_id%type)--Change to tax_id by Chong for bug#16414088 20130320
10455: is
10456: select nvl(sum(decode(jattt.tds_event,'PREPAYMENT APPLICATION',-jatit.tax_amount,jatit.tax_amount)),0)
10457: from jai_ap_tds_inv_taxes jatit

Line 10454: cursor get_amt_for_tax_account(cn_tax_id jai_cmn_taxes_all.tax_id%type)--Change to tax_id by Chong for bug#16414088 20130320

10450: and jatit.threshold_slab_id_single is null;
10451:
10452: --get amount for a tax acount
10453: --cursor get_amt_for_tax_account(cn_tax_account jai_cmn_taxes_all.tax_account_id%type)
10454: cursor get_amt_for_tax_account(cn_tax_id jai_cmn_taxes_all.tax_id%type)--Change to tax_id by Chong for bug#16414088 20130320
10455: is
10456: select nvl(sum(decode(jattt.tds_event,'PREPAYMENT APPLICATION',-jatit.tax_amount,jatit.tax_amount)),0)
10457: from jai_ap_tds_inv_taxes jatit
10458: ,jai_ap_tds_thhold_trxs jattt

Line 10459: ,jai_cmn_taxes_all jcta

10455: is
10456: select nvl(sum(decode(jattt.tds_event,'PREPAYMENT APPLICATION',-jatit.tax_amount,jatit.tax_amount)),0)
10457: from jai_ap_tds_inv_taxes jatit
10458: ,jai_ap_tds_thhold_trxs jattt
10459: ,jai_cmn_taxes_all jcta
10460: where jatit.threshold_trx_id = jattt.threshold_trx_id
10461: and jatit.actual_tax_id = jcta.tax_id
10462: and jatit.threshold_grp_id = pn_threshold_grp_id
10463: and jatit.threshold_slab_id_single is null

Line 10720: ,jai_cmn_taxes_all jcta

10716: --select distinct jcta.tax_account_id
10717: select distinct jcta.tax_id --Change to tax_id by Chong for bug#16414088 20130320
10718: from jai_ap_tds_inv_taxes jatit
10719: ,jai_ap_tds_thhold_trxs jattt
10720: ,jai_cmn_taxes_all jcta
10721: where jattt.threshold_trx_id = jatit.threshold_trx_id
10722: and jatit.actual_tax_id = jcta.tax_id
10723: and jattt.tds_rollbacked is null
10724: and jattt.threshold_grp_id = pn_threshold_grp_id