DBA Data[Home] [Help]

APPS.AP_PAYMENT_SCHEDULES_PKG dependencies on AP_INVOICES_READY_TO_PAY_V

Line 545: FROM ap_invoices_ready_to_pay_v air, ap_system_parameters asp

541: l_wt_amt_to_subtract,
542: 0)))),
543: X_currency_code),0) --Bug7717053, added the decode
544: INTO l_discount_available
545: FROM ap_invoices_ready_to_pay_v air, ap_system_parameters asp
546: WHERE invoice_id = X_invoice_id
547: AND payment_num = X_payment_num;
548: ELSE l_discount_available := 0;
549: END IF;

Line 575: FROM ap_invoices_ready_to_pay_v

571: -1, second_discount_date,
572: DECODE(SIGN(X_check_date - NVL(third_discount_date,sysdate-9000)-1),
573: -1, third_discount_date, due_date))))
574: INTO l_discount_date
575: FROM ap_invoices_ready_to_pay_v
576: WHERE invoice_id = X_invoice_id
577: AND payment_num = X_payment_num;
578:
579: RETURN l_discount_date;