APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_CMN_TAXES_ALL

Line 244: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;

240: v_prepayment_amount_applied NUMBER;
241:
242: /* Bug 4353842. Added by Lakshmi Gopalsami */
243: ln_check_number ap_checks_all.check_number%TYPE;
244: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
245: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
246: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
247: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
248: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;

Line 245: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;

241:
242: /* Bug 4353842. Added by Lakshmi Gopalsami */
243: ln_check_number ap_checks_all.check_number%TYPE;
244: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
245: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
246: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
247: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
248: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;
249:

Line 246: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;

242: /* Bug 4353842. Added by Lakshmi Gopalsami */
243: ln_check_number ap_checks_all.check_number%TYPE;
244: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
245: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
246: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
247: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
248: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;
249:
250: -- added, Harshita for Bug 4525089

Line 247: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;

243: ln_check_number ap_checks_all.check_number%TYPE;
244: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
245: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
246: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
247: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;
248: ln_inv_amt ap_invoices_all.invoice_amount%TYPE;
249:
250: -- added, Harshita for Bug 4525089
251:

Line 387: CURSOR c_tax_rates(p_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE)

383: WHERE
384: check_id = p_check_id;
385: lv_tds_check_date DATE ;
386:
387: CURSOR c_tax_rates(p_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE)
388: IS
389: SELECT
390: NVL(tax_rate,0),
391: (NVL(tax_rate,0) - (NVL(surcharge_rate,0) + NVL(cess_rate,0) + NVL(sh_cess_rate,0))) tds_rate, -- added NVL, Harshita for Bug 4639067 --Added sh_cess_rate by Bgowrava for bug #6195027

Line 396: JAI_CMN_TAXES_ALL jtc

392: NVL(surcharge_rate,0) surcharge_rate,
393: NVL(cess_rate,0),
394: NVL(sh_cess_rate,0) --Added by Bgowrava for Bug#6195027
395: FROM
396: JAI_CMN_TAXES_ALL jtc
397: WHERE
398: tax_id = p_tax_id ;
399: -- ended, Harshita for Bug 4525089
400: --Date 11-05-2007 by Sacsethi for bug 5647248

Line 3264: FROM JAI_CMN_TAXES_ALL

3260: AND global_attribute1 = to_char(p_tax_id);--rchandan for bug#4333488
3261:
3262: CURSOR c_stform_type(p_tax_id IN NUMBER) IS
3263: SELECT stform_type
3264: FROM JAI_CMN_TAXES_ALL
3265: WHERE tax_id = p_tax_id;
3266: /*
3267: CURSOR c_deductee_cnt(p_batch_id IN NUMBER , p_check_number IN NUMBER ) IS
3268: select sum ( count( base_vendor_id ) ) -- distinct removed the distinct