APPS.JAI_AP_IA_DTC_TRIGGER_PKG dependencies on AP_INVOICE_LINES_ALL

Line 70: FROM ap_invoice_lines_all

66:
67: --If GL date in distribution is NULL, get from invoice header
68: CURSOR c_get_lines_acct_date(cp_invoice_id IN ap_invoices_all.invoice_id%TYPE) IS
69: SELECT accounting_date
70: FROM ap_invoice_lines_all
71: WHERE invoice_id = cp_invoice_id
72: AND line_number = 1;
73:
74: cursor c_threshold_breach(p_invoice_id number) is

Line 185: /*Fetch Accouting Date from AP_INVOICE_LINES_ALL if Distributions are not saved yet*/

181: FETCH get_dist_gl_date
182: INTO ld_accounting_date;
183: CLOSE get_dist_gl_date;
184:
185: /*Fetch Accouting Date from AP_INVOICE_LINES_ALL if Distributions are not saved yet*/
186: if (ld_accounting_date is NULL) then
187: OPEN c_get_lines_acct_date(cur_rec.invoice_to_tds_authority_id);
188: FETCH c_get_lines_acct_date
189: INTO ld_accounting_date;

Line 224: /*Fetch Accouting Date from AP_INVOICE_LINES_ALL if Distributions are not saved yet*/

220: FETCH get_dist_gl_date
221: INTO ld_accounting_date;
222: CLOSE get_dist_gl_date;
223:
224: /*Fetch Accouting Date from AP_INVOICE_LINES_ALL if Distributions are not saved yet*/
225: if (ld_accounting_date is NULL) then
226: OPEN c_get_lines_acct_date(cur_rec.invoice_to_vendor_id);
227: FETCH c_get_lines_acct_date
228: INTO ld_accounting_date;