APPS.JAI_AP_DTC_CANCELLATION_PKG dependencies on JAI_AP_TDS_THHOLD_SLABS

Line 180: CURSOR c_jai_ap_tds_thhold_slabs(p_threshold_hdr_id NUMBER,

176: SELECT *
177: FROM jai_ap_tds_thhold_grps
178: WHERE threshold_grp_id = p_threshold_grp_id;
179:
180: CURSOR c_jai_ap_tds_thhold_slabs(p_threshold_hdr_id NUMBER,
181: p_threshold_type VARCHAR2,
182: p_amount NUMBER) IS
183: SELECT threshold_slab_id,
184: threshold_type_id,

Line 188: FROM jai_ap_tds_thhold_slabs

184: threshold_type_id,
185: from_amount,
186: to_amount,
187: tax_rate
188: FROM jai_ap_tds_thhold_slabs
189: WHERE threshold_hdr_id = p_threshold_hdr_id
190: AND threshold_type_id in
191: (SELECT threshold_type_id
192: FROM jai_ap_tds_thhold_types

Line 204: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%ROWTYPE;

200:
201: r_get_threshold_grp_dtl c_get_threshold_grp_dtl%ROWTYPE;
202: ln_effective_invoice_amt NUMBER;
203: ln_effective_inv_amt_after NUMBER;
204: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%ROWTYPE;
205: ln_threshold_slab_id_after jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
206: ln_threshold_slab_id_before jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
207: ln_taxable_amt number := 0;
208: -------------------------------------------------------------------------------

Line 205: ln_threshold_slab_id_after jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;

201: r_get_threshold_grp_dtl c_get_threshold_grp_dtl%ROWTYPE;
202: ln_effective_invoice_amt NUMBER;
203: ln_effective_inv_amt_after NUMBER;
204: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%ROWTYPE;
205: ln_threshold_slab_id_after jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
206: ln_threshold_slab_id_before jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
207: ln_taxable_amt number := 0;
208: -------------------------------------------------------------------------------
209: -- Added by Jia for FP Bug#7312295, End

Line 206: ln_threshold_slab_id_before jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;

202: ln_effective_invoice_amt NUMBER;
203: ln_effective_inv_amt_after NUMBER;
204: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%ROWTYPE;
205: ln_threshold_slab_id_after jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
206: ln_threshold_slab_id_before jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
207: ln_taxable_amt number := 0;
208: -------------------------------------------------------------------------------
209: -- Added by Jia for FP Bug#7312295, End
210:

Line 256: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;

252: ln_trx_invoice_amount NUMBER;
253: lv_new_transaction varchar2(1);
254: lv_token varchar2(4000);
255: --Added by Sanjikum the below 5 variables for bug#5131075(4718907)
256: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
257: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
258: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
259: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
260: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;

Line 258: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;

254: lv_token varchar2(4000);
255: --Added by Sanjikum the below 5 variables for bug#5131075(4718907)
256: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
257: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
258: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
259: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
260: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;
261: ld_ret_accounting_date DATE; -- bug#5131075(5193852). Added by Lakshmi Gopalsami
262: