APPS.AR_BUS_EVENT_SUB_PVT dependencies on RA_CUSTOMER_TRX

Line 227: from ra_customer_trx trx,

223: ra_cm.amount_applied,null)
224: )
225: )
226: )) cm_cl_past_due_inv_amt
227: from ra_customer_trx trx,
228: ar_payment_schedules ps,
229: ra_customer_trx prev_trx,
230: ra_cust_trx_types ctt,
231: ra_terms rt,

Line 229: ra_customer_trx prev_trx,

225: )
226: )) cm_cl_past_due_inv_amt
227: from ra_customer_trx trx,
228: ar_payment_schedules ps,
229: ra_customer_trx prev_trx,
230: ra_cust_trx_types ctt,
231: ra_terms rt,
232: ra_terms_lines rtl,
233: ar_receivable_applications_all ra_cm,

Line 1842: from ra_customer_trx ct,

1838: FOR UPDATE;
1839:
1840: CURSOR get_prev_ctx_id (ctx_id IN NUMBER) IS
1841: select ct.previous_customer_trx_id , ctt.type
1842: from ra_customer_trx ct,
1843: ra_customer_trx prev_ct,
1844: ra_cust_trx_types ctt
1845: where ct.customer_trx_id = ctx_id
1846: and prev_ct.customer_trx_id = ct.previous_customer_trx_id

Line 1843: ra_customer_trx prev_ct,

1839:
1840: CURSOR get_prev_ctx_id (ctx_id IN NUMBER) IS
1841: select ct.previous_customer_trx_id , ctt.type
1842: from ra_customer_trx ct,
1843: ra_customer_trx prev_ct,
1844: ra_cust_trx_types ctt
1845: where ct.customer_trx_id = ctx_id
1846: and prev_ct.customer_trx_id = ct.previous_customer_trx_id
1847: and prev_ct.cust_trx_type_id = ctt.cust_trx_type_id;

Line 2185: from ra_customer_trx

2181: WHERE history_id = p_hist_id;
2182:
2183: CURSOR get_prev_ctx_id (ctx_id IN NUMBER) IS
2184: select previous_customer_trx_id
2185: from ra_customer_trx
2186: where customer_trx_id = ctx_id;
2187:
2188: i INTEGER;
2189: l_key VARCHAR2(240) := p_event.GetEventKey();

Line 6133: from ra_customer_trx trx,

6129: ra_cm.amount_applied,null)
6130: )
6131: )
6132: )) cm_cl_past_due_inv_amt
6133: from ra_customer_trx trx,
6134: ar_payment_schedules ps,
6135: ra_customer_trx prev_trx,
6136: ra_cust_trx_types ctt,
6137: ra_terms rt,

Line 6135: ra_customer_trx prev_trx,

6131: )
6132: )) cm_cl_past_due_inv_amt
6133: from ra_customer_trx trx,
6134: ar_payment_schedules ps,
6135: ra_customer_trx prev_trx,
6136: ra_cust_trx_types ctt,
6137: ra_terms rt,
6138: ra_terms_lines rtl,
6139: ar_receivable_applications_all ra_cm,