APPS.AP_PAYMENT_SCHEDULES_PKG dependencies on AP_INVOICES_READY_TO_PAY_V

Line 558: FROM ap_invoices_ready_to_pay_v air, ap_system_parameters_all asp

554: l_wt_amt_to_subtract,
555: 0)))),
556: X_currency_code),0) --Bug7717053, added the decode
557: INTO l_discount_available
558: FROM ap_invoices_ready_to_pay_v air, ap_system_parameters_all asp
559: WHERE invoice_id = X_invoice_id
560: AND payment_num = X_payment_num
561: AND air.org_id = asp.org_id; --Added for bug #8506044;
562: ELSE l_discount_available := 0;

Line 589: FROM ap_invoices_ready_to_pay_v

585: -1, second_discount_date,
586: DECODE(SIGN(X_check_date - NVL(third_discount_date,sysdate-9000)-1),
587: -1, third_discount_date, due_date))))
588: INTO l_discount_date
589: FROM ap_invoices_ready_to_pay_v
590: WHERE invoice_id = X_invoice_id
591: AND payment_num = X_payment_num;
592:
593: RETURN l_discount_date;