APPS.JAI_AP_TDS_CANCELLATION_PKG dependencies on JAI_AP_TDS_INV_TAXES

Line 129: cursor c_jai_ap_tds_inv_taxes(p_invoice_id number,cp_section_type jai_ap_tds_inv_taxes.section_type%type) is--rchandan for bug#4428980

125: from ap_invoices_all
126: where invoice_id = p_invoice_id;
127:
128:
129: cursor c_jai_ap_tds_inv_taxes(p_invoice_id number,cp_section_type jai_ap_tds_inv_taxes.section_type%type) is--rchandan for bug#4428980
130: select threshold_grp_id,
131: actual_tax_id tax_id,
132: sum(amount) taxable_amount,
133: sum(tax_amount) tax_amount

Line 134: from jai_ap_tds_inv_taxes jtdsi

130: select threshold_grp_id,
131: actual_tax_id tax_id,
132: sum(amount) taxable_amount,
133: sum(tax_amount) tax_amount
134: from jai_ap_tds_inv_taxes jtdsi
135: where invoice_id = p_invoice_id
136: and section_type = cp_section_type --cp_section_type--rchandan for bug#4428980
137: and threshold_grp_id is not null
138: and threshold_trx_id is null

Line 805: for cur_rec in c_jai_ap_tds_inv_taxes(p_invoice_id,'TDS_SECTION')--rchandan for bug#4428980

801:
802: lv_codepath := jai_general_pkg.plot_codepath(22, lv_codepath); /* 22 */
803: ln_exchange_rate := nvl(ln_exchange_rate, 1);
804:
805: for cur_rec in c_jai_ap_tds_inv_taxes(p_invoice_id,'TDS_SECTION')--rchandan for bug#4428980
806: loop
807: lv_codepath := jai_general_pkg.plot_codepath(23, lv_codepath); /* 23 */
808: ln_threshold_grp_id := null;
809: r_ja_in_tax_codes := null;