APPS.ARP_PROCESS_APPLICATION2 dependencies on RA_CUSTOMER_TRX

Line 157: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;

153: l_ship_to_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
154: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
155: l_amount_due_remaining NUMBER;
156: l_claim_amount NUMBER;
157: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
158: l_trx_number ra_customer_trx.trx_number%TYPE;
159: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE;
160: l_salesrep_id ra_customer_trx.primary_salesrep_id%TYPE;
161: --BUG#2750340

Line 158: l_trx_number ra_customer_trx.trx_number%TYPE;

154: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
155: l_amount_due_remaining NUMBER;
156: l_claim_amount NUMBER;
157: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
158: l_trx_number ra_customer_trx.trx_number%TYPE;
159: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE;
160: l_salesrep_id ra_customer_trx.primary_salesrep_id%TYPE;
161: --BUG#2750340
162: l_xla_ev_rec arp_xla_events.xla_events_type;

Line 160: l_salesrep_id ra_customer_trx.primary_salesrep_id%TYPE;

156: l_claim_amount NUMBER;
157: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
158: l_trx_number ra_customer_trx.trx_number%TYPE;
159: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE;
160: l_salesrep_id ra_customer_trx.primary_salesrep_id%TYPE;
161: --BUG#2750340
162: l_xla_ev_rec arp_xla_events.xla_events_type;
163: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
164:

Line 345: FROM ra_customer_trx t

341: , l_ship_to_site_use_id
342: , l_amount_due_remaining
343: , l_salesrep_id -- bug 2361331
344: , l_legal_entity_id
345: FROM ra_customer_trx t
346: , ar_payment_schedules p
347: WHERE t.customer_trx_id = p.customer_trx_id
348: AND p.payment_schedule_id = p_invoice_ps_id;
349: