APPS.AP_PREPAY_UTILS_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 798: FROM ap_payment_schedules_all aps

794:
795: --bug 7506584 starts
796: SELECT SUM(nvl(aps.amount_remaining, 0))
797: INTO l_unpaid_amount
798: FROM ap_payment_schedules_all aps
799: WHERE aps.invoice_id = x_invoice_id;
800:
801: SELECT SUM(decode(line_type_lookup_code, 'TAX', nvl(ail.amount, 0), 0)) l_tax_lines,
802: SUM(decode(line_type_lookup_code, 'TAX', 0, nvl(ail.amount, 0))) l_non_tax_lines,

Line 894: FROM ap_payment_schedules_all aps

890: -- Invoice has any partial payment
891:
892: SELECT SUM(NVL(aps.amount_remaining, 0))
893: INTO l_unpaid_amount
894: FROM ap_payment_schedules_all aps
895: WHERE aps.invoice_id = X_Invoice_Id;
896:
897: -- If the invoice and payment currencies are different
898: -- we need to convert to the invoice currency the amount

Line 1012: FROM ap_payment_schedules_all aps

1008: */
1009:
1010: SELECT SUM(nvl(aps.amount_remaining, 0))
1011: INTO l_unpaid_amount
1012: FROM ap_payment_schedules_all aps
1013: WHERE aps.invoice_id = x_invoice_id;
1014:
1015: -- If the invoice and payment currencies are different
1016: -- we need to convert to the invoice currency the amount