APPS.JAI_AP_TDS_CANCELLATION_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 201: | ap_invoice_distributions_all.accounting_date instead of

197: lv_payment varchar2(1) :='N';
198: /*end-ETDS FVU3.1 11896260*/
199: /* Bug#5131075(5193852). Added by Lakshmi Gopalsami
200: | Changed the source of ld_accounting_date to refer to
201: | ap_invoice_distributions_all.accounting_date instead of
202: | gl_date on headers.
203: */
204: CURSOR get_dist_gl_date( cp_invoice_id IN ap_invoices_all.invoice_id%TYPE)
205: IS

Line 207: FROM ap_invoice_distributions_all

203: */
204: CURSOR get_dist_gl_date( cp_invoice_id IN ap_invoices_all.invoice_id%TYPE)
205: IS
206: SELECT accounting_date
207: FROM ap_invoice_distributions_all
208: WHERE invoice_id = cp_invoice_id
209: AND distribution_line_number = 1;
210: -- Only one distribution will be created for TDS invoices and so
211: -- hard coded the distribution line number to 1.

Line 286: lv_open_period ap_invoice_distributions_all.period_name%type;

282: ln_out_original_prepay_amount number;
283: ln_out_pay_curr_inv_amount number;
284:
285: ld_accounting_date date; --File.Sql.35 Cbabu := sysdate;
286: lv_open_period ap_invoice_distributions_all.period_name%type;
287:
288: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;
289: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;
290: ln_threshold_trx_id number;