DBA Data[Home] [Help]

APPS.AP_PAYMENT_SCHEDULES_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 34: ap_system_parameters.allow_paid_invoice_adjust%TYPE;

30: l_payment_num_to_add number;
31: l_amount_remaining number;
32: l_payment_status_flag ap_payment_schedules.payment_status_flag%TYPE;
33: l_allow_paid_invoice_adjust
34: ap_system_parameters.allow_paid_invoice_adjust%TYPE;
35: l_add_new_payment_schedule varchar2(1) := 'Y';
36: l_sum_ps_amount_remaining number;
37: l_payment_currency_code ap_invoices.payment_currency_code%TYPE;
38: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;

Line 62: ap_system_parameters SP

58: AI.payment_currency_code,
59: AI.payment_cross_rate,
60: nvl(AI.pay_curr_invoice_amount, AI.invoice_amount)
61: from ap_invoices AI,
62: ap_system_parameters SP
63: where invoice_id = X_invoice_id;
64:
65: -- If we're adding a new payment schedule and not adjusting
66: -- an existing one, then the payment_status_flag of the

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;