APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_TAX_ALLOC_AMOUNT_GT

Line 649: INSERT INTO AP_Tax_Alloc_Amount_GT t1

645:
646: /* Inserting into temp table the distribution amount that
647: will be calculated for a tax line */
648:
649: INSERT INTO AP_Tax_Alloc_Amount_GT t1
650: (Invoice_ID,
651: Line_Number,
652: Line_Amount,
653: Line_Base_Amount,

Line 1810: AP_Tax_Alloc_Amount_GT ACA,

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

Line 2225: AP_Tax_Alloc_Amount_GT TAA,

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

Line 2226: AP_Tax_Alloc_Amount_GT TAA1,

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