1173: AEL.Entered_Dr,
1174: AI.Base_Amount Base_Amount_ai,
1175: AI.Invoice_Amount Invoice_Amount_ai,
1176: AIP.invoice_ID invoice_id_aip
1177: FROM AP_Checks_All AC,
1178: AP_System_Parameters_All ASP,
1179: XLA_Upgrade_Dates UPG,
1180: FND_Currencies FC,
1181: XLA_Transaction_Entities_Upg XTE,
1570: ZRD.Tax_Line_id,
1571: AID.Summary_Tax_Line_ID,
1572: AID.Detail_Tax_Dist_ID
1573: /* 7360647 changes end */
1574: FROM AP_Checks_All AC,
1575: AP_System_Parameters_All ASP,
1576: XLA_Upgrade_Dates UPG,
1577: XLA_Transaction_Entities_Upg XTE,
1578: XLA_Events XLE,
1845: ZRD.Tax_Line_id,
1846: AID.Summary_Tax_Line_ID,
1847: AID.Detail_Tax_Dist_ID
1848: /* 7360647 changes end */
1849: FROM AP_Checks_All AC,
1850: AP_System_Parameters_All ASP,
1851: XLA_Upgrade_Dates UPG,
1852: XLA_Transaction_Entities_Upg XTE,
1853: XLA_Events XLE,
2089: UPG.Start_Date Balance_Date,
2090: NVL(XEL.Accounted_Cr,0) - NVL(XEL.Accounted_Dr,0) Remaining_Amount
2091: FROM XLA_AE_Lines XEL,
2092: XLA_AE_Headers XEH,
2093: AP_Checks_ALL AC,
2094: AP_System_Parameters_ALL ASP,
2095: XLA_Upgrade_Dates UPG
2096: WHERE XEL.Accounting_Class_Code = 'FUTURE_DATED_PMT'
2097: AND XEL.AE_Header_ID = XEH.AE_Header_ID
2315:
2316: END LOOP;
2317:
2318:
2319: l_table_name := 'AP_CHECKS_ALL';
2320: l_script_name := p_pay_script_name;
2321: --l_id_column := 'CHECK_ID';
2322:
2323: --Start 8725986