APPS.JAI_AP_DTC_CANCELLATION_PKG dependencies on AP_INVOICE_LINES_ALL

Line 165: /*Bug 8830302 - Get Accounting Date from AP_INVOICE_LINES_ALL.

161: AND distribution_line_number = 1;
162: -- Only one distribution will be created for TDS invoices and so
163: -- hard coded the distribution line number to 1.
164:
165: /*Bug 8830302 - Get Accounting Date from AP_INVOICE_LINES_ALL.
166: This is fail safe if Distributions does not have accounting date*/
167: CURSOR c_get_lines_acct_date(cp_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS
168: SELECT accounting_date
169: FROM ap_invoice_lines_all

Line 169: FROM ap_invoice_lines_all

165: /*Bug 8830302 - Get Accounting Date from AP_INVOICE_LINES_ALL.
166: This is fail safe if Distributions does not have accounting date*/
167: CURSOR c_get_lines_acct_date(cp_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS
168: SELECT accounting_date
169: FROM ap_invoice_lines_all
170: WHERE invoice_id = cp_invoice_id
171: AND line_number = 1;
172:
173: -- Added by Jia for FP Bug#7312295, Begin

Line 429: /*Bug 8830302 - Fetch Accouting Date from AP_INVOICE_LINES_ALL if Distributions are not saved yet*/

425: FETCH get_dist_gl_date
426: INTO ld_accounting_date;
427: CLOSE get_dist_gl_date;
428:
429: /*Bug 8830302 - Fetch Accouting Date from AP_INVOICE_LINES_ALL if Distributions are not saved yet*/
430: if (ld_accounting_date is NULL) then
431: OPEN c_get_lines_acct_date(cur_rec.invoice_to_tds_authority_id);
432: FETCH c_get_lines_acct_date
433: INTO ld_accounting_date;

Line 608: /*Bug 8830302 - Fetch Accouting Date from AP_INVOICE_LINES_ALL if Distributions are not saved yet*/

604: FETCH get_dist_gl_date
605: INTO ld_accounting_date;
606: CLOSE get_dist_gl_date;
607:
608: /*Bug 8830302 - Fetch Accouting Date from AP_INVOICE_LINES_ALL if Distributions are not saved yet*/
609: if (ld_accounting_date is NULL) then
610: OPEN c_get_lines_acct_date(cur_rec.invoice_to_vendor_id);
611: FETCH c_get_lines_acct_date
612: INTO ld_accounting_date;