APPS.ARRX_BSS dependencies on AR_PAYMENT_SCHEDULES

Line 31: l_new_ADR AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

27: l_balance_due NUMBER;
28: l_functional_balance_due NUMBER;
29: l_applied_amount NUMBER;
30: l_functional_applied_amount NUMBER;
31: l_new_ADR AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
32: l_new_acctd_ADR AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%TYPE;
33:
34: -- Declare variables for Dynamic Cursors
35: v_CursorID_main INTEGER;

Line 32: l_new_acctd_ADR AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%TYPE;

28: l_functional_balance_due NUMBER;
29: l_applied_amount NUMBER;
30: l_functional_applied_amount NUMBER;
31: l_new_ADR AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
32: l_new_acctd_ADR AR_PAYMENT_SCHEDULES.acctd_amount_due_remaining%TYPE;
33:
34: -- Declare variables for Dynamic Cursors
35: v_CursorID_main INTEGER;
36: v_Dummy_main INTEGER;

Line 51: v_ps_exchange_rate AR_PAYMENT_SCHEDULES.exchange_rate%TYPE;

47: v_currency_code RA_CUSTOMER_TRX.invoice_currency_code%TYPE;
48: v_balance_due NUMBER;
49: v_functional_balance_due NUMBER;
50: v_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
51: v_ps_exchange_rate AR_PAYMENT_SCHEDULES.exchange_rate%TYPE;
52:
53: BEGIN
54:
55: -- Initialise status parameters

Line 140: ,ar_payment_schedules_all ps

136: ,ps.exchange_rate
137: FROM ra_cust_trx_types_all ctt
138: ,ra_customer_trx_all trx
139: ,ar_transaction_history_all rah
140: ,ar_payment_schedules_all ps
141: WHERE trx.cust_trx_type_id = ctt.cust_trx_type_id
142: AND rah.customer_trx_id = trx.customer_trx_id
143: AND rah.transaction_history_id = (SELECT MAX(rah1.transaction_history_id)
144: FROM ar_transaction_history_all rah1

Line 159: ar_payment_schedules_all ps,

155: 'AND trx.cust_trx_type_id = :b_transaction_type_id ';
156:
157: l_applied := 'SELECT nvl(app.amount_applied,0)
158: FROM ra_customer_trx_all trx,
159: ar_payment_schedules_all ps,
160: ar_receivable_applications_all app
161: WHERE trx.customer_trx_id = ps.customer_trx_id
162: AND trx.customer_trx_id = app.applied_customer_trx_id
163: AND app.applied_customer_trx_id = :b_trx_id '||