APPS.AP_XLA_UPGRADE_PKG dependencies on AP_CHECKS_ALL

Line 913: FROM AP_Checks_All AC,

909: * AID.Amount / DECODE(AID1.Amount,0,1,AID1.Amount)) Entered_Amt,
910: NVL2(AEL.Account_Overlay_Source_ID, AID1.Invoice_Distribution_ID, 1) Partkey,
911: FC.Minimum_Accountable_Unit,
912: FC.Precision
913: FROM AP_Checks_All AC,
914: AP_System_Parameters_All ASP,
915: XLA_Upgrade_Dates UPG,
916: AP_Accounting_Events_All AAE,
917: AP_Invoice_Payments_All AIP,

Line 1066: FROM AP_Checks_All AC,

1062: 'S' Line_Definition_Owner_Code,
1063: 'ACCRUAL_PAYMENTS_ALL' Line_Definition_Code,
1064: 'PAYMENTS' Event_Class_Code,
1065: 'PAYMENTS_ALL' Event_Type_Code
1066: FROM AP_Checks_All AC,
1067: AP_System_Parameters_All ASP,
1068: XLA_Upgrade_Dates UPG,
1069: AP_Accounting_Events_All AAE,
1070: AP_Payment_History_All APH,

Line 1262: AP_Checks_ALL AC,

1258: UPG.Start_Date Balance_Date,
1259: NVL(XEL.Accounted_Cr,0) - NVL(XEL.Accounted_Dr,0) Remaining_Amount
1260: FROM XLA_AE_Lines XEL,
1261: XLA_AE_Headers XEH,
1262: AP_Checks_ALL AC,
1263: AP_System_Parameters_ALL ASP,
1264: XLA_Upgrade_Dates UPG
1265: WHERE XEL.Accounting_Class_Code = 'FUTURE_DATED_PMT'
1266: AND XEL.AE_Header_ID = XEH.AE_Header_ID

Line 1502: l_table_name := 'AP_CHECKS_ALL';

1498:
1499: END LOOP;
1500:
1501:
1502: l_table_name := 'AP_CHECKS_ALL';
1503: l_script_name := p_pay_script_name;
1504: l_id_column := 'CHECK_ID';
1505:
1506: l_sql_stmt := 'SELECT MIN(AC.CHECK_ID), MAX(AC.CHECK_ID) ' ||

Line 1507: 'FROM AP_CHECKS_ALL AC, ' ||

1503: l_script_name := p_pay_script_name;
1504: l_id_column := 'CHECK_ID';
1505:
1506: l_sql_stmt := 'SELECT MIN(AC.CHECK_ID), MAX(AC.CHECK_ID) ' ||
1507: 'FROM AP_CHECKS_ALL AC, ' ||
1508: ' XLA_UPGRADE_DATES GPS, ' ||
1509: ' AP_SYSTEM_PARAMETERS_ALL ASP ' ||
1510: 'WHERE TRUNC(AC.Check_Date) BETWEEN GPS.Start_Date ' ||
1511: ' AND GPS.End_Date ' ||