APPS.ARP_ARXVASUM_AMT dependencies on AR_PAYMENT_SCHEDULES

Line 13: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

9: p_start_date IN gl_period_statuses.start_date%TYPE,
10: p_end_date IN gl_period_statuses.end_date%TYPE,
11: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
12: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
13: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
14: p_func_curr IN VARCHAR2,
15: p_exc_rate IN NUMBER,
16: p_precision IN NUMBER,
17: p_min_acc_unit IN NUMBER

Line 34: ar_payment_schedules ps,

30: into p_financecharg_amount,
31: p_financecharg_func_amt,
32: p_financecharg_count
33: from ar_adjustments a,
34: ar_payment_schedules ps,
35: ar_receivables_trx rt
36: where
37: a.gl_date between p_start_date
38: and p_end_date

Line 68: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

64: p_start_date IN gl_period_statuses.start_date%TYPE,
65: p_end_date IN gl_period_statuses.end_date%TYPE,
66: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
67: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
68: p_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
69: p_func_curr IN VARCHAR2,
70: p_exc_rate IN NUMBER,
71: p_precision IN NUMBER,
72: p_min_acc_unit IN NUMBER

Line 101: FROM ar_payment_schedules ps,

97: p_earned_func_disc,
98: p_unearned_func_disc,
99: p_earned_disc_count,
100: p_unearned_disc_count
101: FROM ar_payment_schedules ps,
102: ar_receivable_applications ra
103: where
104: ra.gl_date between p_start_date
105: and p_end_date