APPS.JAI_AP_TDS_CANCELLATION_PKG dependencies on JAI_AP_TDS_THHOLD_TRXS

Line 86: cursor c_jai_ap_tds_thhold_trxs (p_invoice_id number,cp_tds_event jai_ap_tds_thhold_trxs.tds_event%type) is--rchandan for bug#4428980

82: p_invoice_id in number
83: )
84: is
85:
86: cursor c_jai_ap_tds_thhold_trxs (p_invoice_id number,cp_tds_event jai_ap_tds_thhold_trxs.tds_event%type) is--rchandan for bug#4428980
87: select threshold_trx_id,
88: threshold_grp_id,
89: threshold_hdr_id, --Added by Sanjikum for Bug#5131075(4718907)
90: tax_id,

Line 95: from jai_ap_tds_thhold_trxs

91: taxable_amount,
92: tax_amount,
93: invoice_to_tds_authority_id,
94: invoice_to_vendor_id
95: from jai_ap_tds_thhold_trxs
96: where invoice_id = p_invoice_id
97: and tds_event = cp_tds_event;--rchandan for bug#4428980
98:
99: cursor c_ja_in_tax_codes(p_tax_id number) is

Line 256: for cur_rec in c_jai_ap_tds_thhold_trxs(p_invoice_id,'INVOICE VALIDATE')

252:
253: lv_codepath := jai_general_pkg.plot_codepath(2, lv_codepath); /* 2 */
254:
255: /* Get all the TDS invoices that were generated at the time of the INVOICE VALIDATE */
256: for cur_rec in c_jai_ap_tds_thhold_trxs(p_invoice_id,'INVOICE VALIDATE')
257: loop
258:
259: --Start Added by Sanjikum for Bug#5131075(4718907)
260: jai_ap_tds_generation_pkg.get_tds_threshold_slab(