DBA Data[Home] [Help]

APPS.ARP_CHARGEBACK_COVER dependencies on AR_CASH_RECEIPTS

Line 90: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

86: l_dum_sec_app_ref_id NUMBER;
87: l_payment_set_id NUMBER;
88: l_attribute_rec AR_Receipt_API_PUB.attribute_rec_type;
89: l_global_attribute_rec AR_Receipt_API_PUB.global_attribute_rec_type;
90: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
91: l_receipt_date DATE;
92: l_trx_date DATE;
93: l_cr_gl_date DATE;
94: l_cr_payment_schedule_id NUMBER;

Line 95: l_currency_code ar_cash_receipts.currency_code%TYPE;

91: l_receipt_date DATE;
92: l_trx_date DATE;
93: l_cr_gl_date DATE;
94: l_cr_payment_schedule_id NUMBER;
95: l_currency_code ar_cash_receipts.currency_code%TYPE;
96: l_exchange_rate NUMBER;
97: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
98: l_exchange_rate_date DATE;
99: l_bill_to_site_use_id NUMBER;

Line 97: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

93: l_cr_gl_date DATE;
94: l_cr_payment_schedule_id NUMBER;
95: l_currency_code ar_cash_receipts.currency_code%TYPE;
96: l_exchange_rate NUMBER;
97: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
98: l_exchange_rate_date DATE;
99: l_bill_to_site_use_id NUMBER;
100: l_remit_to_address_id NUMBER;
101: l_cb_exchange_rate NUMBER;

Line 102: l_cb_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;

98: l_exchange_rate_date DATE;
99: l_bill_to_site_use_id NUMBER;
100: l_remit_to_address_id NUMBER;
101: l_cb_exchange_rate NUMBER;
102: l_cb_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
103: l_cb_exchange_rate_date DATE;
104: l_cb_currency_code ar_cash_receipts.currency_code%TYPE;
105: l_cb_bill_to_site_use_id NUMBER;
106: l_cb_remit_to_address_id NUMBER;

Line 104: l_cb_currency_code ar_cash_receipts.currency_code%TYPE;

100: l_remit_to_address_id NUMBER;
101: l_cb_exchange_rate NUMBER;
102: l_cb_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
103: l_cb_exchange_rate_date DATE;
104: l_cb_currency_code ar_cash_receipts.currency_code%TYPE;
105: l_cb_bill_to_site_use_id NUMBER;
106: l_cb_remit_to_address_id NUMBER;
107: l_cb_amount NUMBER;
108: l_cb_acctd_amount NUMBER;

Line 212: FROM ar_cash_receipts cr

208: , l_exchange_rate
209: , l_exchange_rate_type
210: , l_exchange_rate_date
211: , l_bill_to_site_use_id
212: FROM ar_cash_receipts cr
213: , ar_payment_schedules ps
214: , ar_cash_receipt_history crh
215: WHERE cr.cash_receipt_id = crh.cash_receipt_id(+)
216: AND crh.first_posted_record_flag(+) = 'Y'