APPS.JAI_AP_DTC_CANCELLATION_PKG dependencies on JAI_AP_TDS_THHOLD_TYPES

Line 192: FROM jai_ap_tds_thhold_types

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
193: WHERE threshold_hdr_id = p_threshold_hdr_id
194: AND threshold_type = p_threshold_type
195: AND trunc(sysdate) between from_date and
196: nvl(to_date, sysdate + 1))

Line 257: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;

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;
261: ld_ret_accounting_date DATE; -- bug#5131075(5193852). Added by Lakshmi Gopalsami

Line 259: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;

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:
263: lv_proc_name VARCHAR2 (100) := 'process_invoice_cancellation';