APPS.AP_INVOICE_CORRECTIONS_PKG dependencies on AP_INVOICE_LINES_ALL

Line 180: From ap_invoice_lines_all

176: l_debug_info := 'Get Line Included Tax Amount';
177: Begin
178: Select nvl(included_tax_amount, 0)
179: Into l_included_tax_amount
180: From ap_invoice_lines_all
181: Where invoice_id = x_invoice_id
182: And line_number = x_invoice_line_number;
183: Exception
184: When Others Then

Line 410: FROM ap_invoice_lines_all ail

406: current_calling_sequence := 'Get_Line_Proration_Total <- '||x_calling_sequence;
407:
408: SELECT sum(ail.amount)
409: INTO l_line_total
410: FROM ap_invoice_lines_all ail
411: WHERE ail.invoice_id = x_corrected_invoice_id
412: AND ail.line_type_lookup_code = 'ITEM'; -- Bug 5597409
413:
414: RETURN(l_line_total);

Line 874: From ap_invoice_lines_all

870:
871: Begin
872: Select nvl(included_tax_amount, 0)
873: Into x_line_tab(i).included_tax_amount
874: From ap_invoice_lines_all
875: Where invoice_id = x_invoice_id
876: And line_number = x_line_tab(i).line_number;
877:
878: Exception

Line 972: INSERT INTO AP_INVOICE_LINES_ALL (

968:
969:
970: l_debug_info := 'Inserting non-matched Item Line';
971:
972: INSERT INTO AP_INVOICE_LINES_ALL (
973: INVOICE_ID,
974: LINE_NUMBER,
975: LINE_TYPE_LOOKUP_CODE,
976: REQUESTER_ID,