APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_TAX_ALLOC_AMOUNT_GT

Line 628: INSERT INTO AP_Tax_Alloc_Amount_GT t1

624:
625: /* Inserting into temp table the distribution amount that
626: will be calculated for a tax line */
627:
628: INSERT INTO AP_Tax_Alloc_Amount_GT t1
629: (Invoice_ID,
630: Line_Number,
631: Line_Amount,
632: Line_Base_Amount,

Line 1812: AP_Tax_Alloc_Amount_GT ACA,

1808: 'Y' Historical_Flag,
1809: 'N' RCV_Charge_Addition_Flag
1810: FROM AP_Invoices_ALL AI,
1811: AP_Dist_Line_GT AID,
1812: AP_Tax_Alloc_Amount_GT ACA,
1813: AP_Line_Temp_GT Line
1814: WHERE AI.Invoice_ID = AID.Invoice_ID
1815: AND AID.Line_Type_Lookup_Code IN ('ITEM', 'PREPAY', 'AWT', 'ICMS',
1816: 'IPI', 'FREIGHT', 'MISCELLANEOUS')

Line 2227: AP_Tax_Alloc_Amount_GT TAA,

2223: FROM AP_System_Parameters_All ASP,
2224: AP_Invoices_ALL AI,
2225: FND_Currencies FC,
2226: AP_Dist_Line_GT AID,
2227: AP_Tax_Alloc_Amount_GT TAA,
2228: AP_Tax_Alloc_Amount_GT TAA1,
2229: AP_Dist_Line_GT AID1,
2230: (SELECT AID.Invoice_Distribution_ID Item_Dist_ID,
2231: AID.Amount Item_Amount,

Line 2228: AP_Tax_Alloc_Amount_GT TAA1,

2224: AP_Invoices_ALL AI,
2225: FND_Currencies FC,
2226: AP_Dist_Line_GT AID,
2227: AP_Tax_Alloc_Amount_GT TAA,
2228: AP_Tax_Alloc_Amount_GT TAA1,
2229: AP_Dist_Line_GT AID1,
2230: (SELECT AID.Invoice_Distribution_ID Item_Dist_ID,
2231: AID.Amount Item_Amount,
2232: AID.Base_Amount Item_Base_Amount,