APPS.FII_AP_INV_SUM_INC dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 1468: AP_Payment_Schedules_All PS

1464: PS.Created_By Created_By,
1465: NULL Fully_Paid_Date
1466: BULK COLLECT INTO FII_AP_Pay_Sched_MS
1467: FROM FII_AP_Invoice_IDS ID,
1468: AP_Payment_Schedules_All PS
1469: WHERE ID.Invoice_ID = PS.Invoice_ID
1470: AND (ID.Invoice_B_Flag = 'Y' OR ID.Pay_Sched_B_Flag = 'Y')
1471: ORDER BY PS.Invoice_ID, PS.Payment_Num;
1472:

Line 4465: FROM AP_Payment_Schedules_All PS

4461: UNION
4462: SELECT PS.Invoice_ID Invoice_ID,
4463: 'OTHER' Table_Name,
4464: 'U' Operation_Flag
4465: FROM AP_Payment_Schedules_All PS
4466: WHERE Payment_Status_Flag IN ('N', 'P')
4467: AND ((g_last_start_date <= TRUNC(PS.Discount_Date)
4468: AND TRUNC(PS.Discount_Date) < g_sysdate)
4469: OR (g_last_start_date <= TRUNC(PS.Second_Discount_Date)