APPS.FII_AP_INV_SUM_INC dependencies on AP_CHECKS_ALL

Line 1496: AP_Checks_ALL AC,

1492: ,DECODE(IBY_SYS_PROF_B.Processing_Type, 'ELECTRONIC', 'E', 'M')) Processing_Type
1493: BULK COLLECT INTO FII_AP_Inv_Pay_MS
1494: FROM FII_AP_Invoice_IDS ID,
1495: AP_Invoice_Payments_ALL AIP,
1496: AP_Checks_ALL AC,
1497: IBY_SYS_PMT_PROFILES_B IBY_SYS_PROF_B, --IBY CHANGE
1498: IBY_ACCT_PMT_PROFILES_B IBY_ACCT_PROF_B--IBY CHANGE
1499: WHERE ID.Invoice_ID = AIP.Invoice_ID
1500: AND AIP.Check_ID = AC.Check_ID

Line 1585: AP_Checks_All AC,

1581: GROUP BY AID.Invoice_ID, TRUNC(AID.Creation_Date), TEMP.Invoice_ID) TEMP1,
1582: AP_Invoice_Payments_All AIP
1583: WHERE TEMP1.Prepay_Invoice_ID = AIP.Invoice_ID
1584: GROUP BY TEMP1.Invoice_ID, TEMP1.Creation_Date, TEMP1.Prepay_Invoice_ID, TEMP1.Amount) TEMP2,
1585: AP_Checks_All AC,
1586: IBY_SYS_PMT_PROFILES_B IBY_SYS_PROF_B,--IBY CHANGE
1587: IBY_ACCT_PMT_PROFILES_B IBY_ACCT_PROF_B--IBY CHANGE
1588: WHERE TEMP2.Check_ID = AC.Check_ID
1589: AND AC.Payment_Profile_ID = IBY_ACCT_PROF_B.Payment_Profile_ID(+)--IBY CHANGE