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: --Modified below condition for bug#10410133
413: --from " = 'ITEM' to in ('ITEM','FREIGHT','MISCELLANEOUS') "
414: -- Bug 5597409, restricting for Item line only

Line 901: From ap_invoice_lines_all

897:
898: Begin
899: Select nvl(included_tax_amount, 0)
900: Into x_line_tab(i).included_tax_amount
901: From ap_invoice_lines_all
902: Where invoice_id = x_invoice_id
903: And line_number = x_line_tab(i).line_number;
904:
905: Exception

Line 999: INSERT INTO AP_INVOICE_LINES_ALL (

995:
996:
997: l_debug_info := 'Inserting non-matched Item Line';
998:
999: INSERT INTO AP_INVOICE_LINES_ALL (
1000: INVOICE_ID,
1001: LINE_NUMBER,
1002: LINE_TYPE_LOOKUP_CODE,
1003: REQUESTER_ID,