APPS.AP_PREPAY_UTILS_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 826: FROM ap_payment_schedules_all aps

822: --bug 7506584 starts
823: --unpaid amount in payment currency
824: SELECT SUM(nvl(aps.amount_remaining, 0))
825: INTO l_unpaid_amount
826: FROM ap_payment_schedules_all aps
827: WHERE aps.invoice_id = x_invoice_id;
828:
829: /*Bug9338463 :comments - l_tax_lines and l_non_tax_lines though includes prepay it would
830: only be used when no payment or prepayment exists*/

Line 998: FROM ap_payment_schedules_all aps

994: -- Invoice has any partial payment
995:
996: SELECT SUM(NVL(aps.amount_remaining, 0))
997: INTO l_unpaid_amount
998: FROM ap_payment_schedules_all aps
999: WHERE aps.invoice_id = X_Invoice_Id;
1000:
1001: -- If the invoice and payment currencies are different
1002: -- we need to convert to the invoice currency the amount

Line 1116: FROM ap_payment_schedules_all aps

1112: */
1113:
1114: SELECT SUM(nvl(aps.amount_remaining, 0))
1115: INTO l_unpaid_amount
1116: FROM ap_payment_schedules_all aps
1117: WHERE aps.invoice_id = x_invoice_id;
1118:
1119: -- If the invoice and payment currencies are different
1120: -- we need to convert to the invoice currency the amount