APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_CMN_TAXES_ALL

Line 491: from jai_cmn_taxes_all

487: and invoice_distribution_id = p_invoice_distribution_id;
488:
489: cursor c_get_tax_rate(p_tax_id number) is
490: select tax_rate
491: from jai_cmn_taxes_all
492: where tax_id = p_tax_id;
493:
494: ln_tax_id number;
495: ln_tax_rate number;

Line 841: from JAI_CMN_TAXES_ALL

837: end_date,
838: sysdate,
839: 'Tax : ' || tax_name || ' is end dated as on ' || to_char(end_date, 'dd-mon-yyyy') ||
840: '. Setup needs modification.' tax_end_dated_message
841: from JAI_CMN_TAXES_ALL
842: where tax_id = p_tax_id;
843: /*Bug 5751783 - Selected non-rounded value for calculation*/
844: 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
845: select actual_section_code, (sum(amount*p_exchange_rate)-p_prepay_amt) invoice_amount, sum(calc_tax_amount) section_amount,

Line 1025: jai_cmn_taxes_all jitc

1021: jattt.tax_id tax_id,
1022: (jitc.tax_rate-(nvl(jitc.surcharge_rate,0) + nvl(jitc.cess_rate,0) + nvl(jitc.sh_cess_rate,0))) tax_rate_orig
1023: from jai_ap_tds_thhold_slabs jatts,
1024: jai_ap_tds_thhold_taxes jattt,
1025: jai_cmn_taxes_all jitc
1026: where jatts.threshold_slab_id = jattt.threshold_slab_id
1027: and jattt.tax_id = jitc.tax_id
1028: and jatts.threshold_slab_id = p_threshold_slab_id;
1029:

Line 1064: from jai_cmn_taxes_all jitc, jai_ap_tds_inv_taxes jatit

1060: and invoice_id = p_invoice_id
1061: and (actual_section_code is not null or default_section_code is not null);
1062: */ --Commented by Jiaf or FP Bug#8278439
1063: select jitc.section_code section_code
1064: from jai_cmn_taxes_all jitc, jai_ap_tds_inv_taxes jatit
1065: where jitc.tax_id = nvl(jatit.actual_tax_id, jatit.default_tax_id)
1066: and jatit.section_type = 'TDS_SECTION'
1067: and jatit.invoice_id = p_invoice_id
1068: and (actual_tax_id is not null or default_tax_id is not null);

Line 1993: from JAI_CMN_TAXES_ALL

1989: tax_rate,
1990: stform_type,
1991: tax_account_id,
1992: section_type
1993: from JAI_CMN_TAXES_ALL
1994: where tax_id = pn_tax_id;
1995:
1996:
1997: cursor c_gl_sets_of_books(cp_set_of_books_id number) is

Line 2861: from JAI_CMN_TAXES_ALL

2857: where threshold_grp_id = cp_threshold_grp_id;
2858:
2859: cursor c_ja_in_tax_codes(cp_tax_id number) is
2860: select tax_rate, surcharge_rate, cess_rate, sh_cess_rate, section_code --Added surcharge_rate, cess_rate, sh_cess_rate, section_code by Bgowrava for bug#8254510
2861: from JAI_CMN_TAXES_ALL
2862: where tax_id = cp_tax_id;
2863:
2864: /* Bug 5751783. Get the sum of invoice amount for which TDS is not calculated*/
2865: CURSOR get_tds_not_deducted ( cp_threshold_grp_id IN NUMBER )