APPS.JAI_AP_TDS_CANCELLATION_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 148: | ap_invoice_distributions_all.accounting_date instead of

144: where set_of_books_id = cp_set_of_books_id;
145:
146: /* Bug#5131075(5193852). Added by Lakshmi Gopalsami
147: | Changed the source of ld_accounting_date to refer to
148: | ap_invoice_distributions_all.accounting_date instead of
149: | gl_date on headers.
150: */
151: CURSOR get_dist_gl_date( cp_invoice_id IN ap_invoices_all.invoice_id%TYPE)
152: IS

Line 154: FROM ap_invoice_distributions_all

150: */
151: CURSOR get_dist_gl_date( cp_invoice_id IN ap_invoices_all.invoice_id%TYPE)
152: IS
153: SELECT accounting_date
154: FROM ap_invoice_distributions_all
155: WHERE invoice_id = cp_invoice_id
156: AND distribution_line_number = 1;
157: -- Only one distribution will be created for TDS invoices and so
158: -- hard coded the distribution line number to 1.

Line 190: lv_open_period ap_invoice_distributions_all.period_name%type;

186: ln_out_original_prepay_amount number;
187: ln_out_pay_curr_inv_amount number;
188:
189: ld_accounting_date date; --File.Sql.35 Cbabu := sysdate;
190: lv_open_period ap_invoice_distributions_all.period_name%type;
191:
192: lv_invoice_to_tds_num ap_invoices_all.invoice_num%type;
193: lv_invoice_to_vendor_num ap_invoices_all.invoice_num%type;
194: ln_threshold_trx_id number;