APPS.ARP_PROCESS_APPLICATION2 dependencies on RA_CUSTOMER_TRX

Line 153: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;

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

Line 154: l_trx_number ra_customer_trx.trx_number%TYPE;

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

Line 156: l_salesrep_id ra_customer_trx.primary_salesrep_id%TYPE;

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

Line 334: FROM ra_customer_trx t

330: , l_ship_to_site_use_id
331: , l_amount_due_remaining
332: , l_salesrep_id -- bug 2361331
333: , l_legal_entity_id
334: FROM ra_customer_trx t
335: , ar_payment_schedules p
336: WHERE t.customer_trx_id = p.customer_trx_id
337: AND p.payment_schedule_id = p_invoice_ps_id;
338: