APPS.ARRX_BRS dependencies on AR_RECEIVABLE_APPLICATIONS

Line 170: v_amount_applied AR_RECEIVABLE_APPLICATIONS.amount_applied%TYPE;

166: v_drawee_address3 HZ_LOCATIONS.address3%TYPE;
167: v_drawee_contact VARCHAR2(100);
168: v_special_instructions RA_CUSTOMER_TRX.special_instructions%TYPE;
169: v_status_code AR_TRANSACTION_HISTORY.status%TYPE;
170: v_amount_applied AR_RECEIVABLE_APPLICATIONS.amount_applied%TYPE;
171: v_functional_amount_applied AR_RECEIVABLE_APPLICATIONS.amount_applied%TYPE;
172: v_ps_exchange_rate AR_PAYMENT_SCHEDULES.exchange_rate%TYPE;
173:
174:

Line 171: v_functional_amount_applied AR_RECEIVABLE_APPLICATIONS.amount_applied%TYPE;

167: v_drawee_contact VARCHAR2(100);
168: v_special_instructions RA_CUSTOMER_TRX.special_instructions%TYPE;
169: v_status_code AR_TRANSACTION_HISTORY.status%TYPE;
170: v_amount_applied AR_RECEIVABLE_APPLICATIONS.amount_applied%TYPE;
171: v_functional_amount_applied AR_RECEIVABLE_APPLICATIONS.amount_applied%TYPE;
172: v_ps_exchange_rate AR_PAYMENT_SCHEDULES.exchange_rate%TYPE;
173:
174:
175:

Line 298: ar_receivable_applications_all app

294:
295: -- Open Amounts Cursor
296: l_open_amount := 'SELECT nvl(SUM(app.amount_applied),0)
297: FROM ra_customer_trx_all trx,
298: ar_receivable_applications_all app
299: WHERE trx.customer_trx_id = app.applied_customer_trx_id
300: AND app.applied_customer_trx_id = :b_trx_id '||
301: l_org_where_trx ||
302: l_org_where_app ||

Line 310: ar_receivable_applications_all app,

306: -- Unpaid Receipt Reversal Reason Cursor
307: l_receipt_reversal := 'SELECT distinct DECODE(cr.reversal_reason_code, NULL, NULL
308: , initcap(arl.meaning))
309: FROM ar_cash_receipts_all cr,
310: ar_receivable_applications_all app,
311: ar_lookups arl
312: WHERE cr.cash_receipt_id = app.cash_receipt_id '||
313: l_org_where_app ||
314: l_org_where_cr ||