APPS.JAI_AP_TDS_CANCELLATION_PKG dependencies on JAI_AP_TDS_THHOLD_TYPES

Line 239: FROM jai_ap_tds_thhold_types

235: FROM jai_ap_tds_thhold_slabs
236: WHERE threshold_hdr_id = p_threshold_hdr_id
237: AND threshold_type_id in
238: ( SELECT threshold_type_id
239: FROM jai_ap_tds_thhold_types
240: WHERE threshold_hdr_id = p_threshold_hdr_id
241: AND threshold_type = p_threshold_type
242: AND trunc(sysdate) between from_date and nvl(to_date, sysdate + 1)
243: )

Line 302: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;

298: lv_new_transaction varchar2(1);
299: lv_token varchar2(4000);
300: --Added by Sanjikum the below 5 variables for bug#5131075(4718907)
301: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
302: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
303: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
304: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
305: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;
306: ld_ret_accounting_date DATE ; -- bug#5131075(5193852). Added by Lakshmi Gopalsami

Line 304: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;

300: --Added by Sanjikum the below 5 variables for bug#5131075(4718907)
301: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
302: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
303: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
304: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
305: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;
306: ld_ret_accounting_date DATE ; -- bug#5131075(5193852). Added by Lakshmi Gopalsami
307:
308: lv_threshold_type_before jai_ap_tds_thhold_types.threshold_type%TYPE; /*Bug 13561970*/

Line 308: lv_threshold_type_before jai_ap_tds_thhold_types.threshold_type%TYPE; /*Bug 13561970*/

304: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
305: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;
306: ld_ret_accounting_date DATE ; -- bug#5131075(5193852). Added by Lakshmi Gopalsami
307:
308: lv_threshold_type_before jai_ap_tds_thhold_types.threshold_type%TYPE; /*Bug 13561970*/
309:
310: begin
311:
312: --ld_accounting_date := sysdate; --commented by Harshita for Bug#5131075(5193852)