APPS.AR_BUS_EVENT_SUB_PVT dependencies on AR_ADJUSTMENTS

Line 6297: FROM ar_adjustments adj,

6293: SELECT sum(amount),count(adj.adjustment_id) adj_count,
6294: ps.customer_id, ps.customer_site_use_id,
6295: ps.invoice_currency_code, adj.apply_date,
6296: ps.class, ps.due_date, adj.status
6297: FROM ar_adjustments adj,
6298: ar_payment_schedules ps
6299: WHERE adj.request_id = p_req_id
6300: and adj.payment_schedule_id = ps.payment_schedule_id
6301: group by ps.customer_id,

Line 6521: FROM ar_adjustments adj,

6517: CURSOR get_adj_details (p_adj_id IN NUMBER) IS
6518: SELECT adj.amount, adj.apply_date, adj.receivables_trx_id,
6519: ps.customer_id, ps.customer_site_use_id, ps.invoice_currency_code,
6520: ps.class, ps.due_date
6521: FROM ar_adjustments adj,
6522: ar_payment_schedules ps
6523: WHERE adj.payment_schedule_id = ps.payment_schedule_id
6524: and adj.adjustment_id = p_adj_id ;
6525: l_past_due_inv_inst_count NUMBER;

Line 6678: FROM ar_adjustments adj,

6674: CURSOR get_adj_details (p_adj_id IN NUMBER) IS
6675: SELECT adj.amount, adj.apply_date, adj.receivables_trx_id,
6676: ps.customer_id, ps.customer_site_use_id, ps.invoice_currency_code,
6677: ps.class, ps.due_date
6678: FROM ar_adjustments adj,
6679: ar_payment_schedules ps
6680: WHERE adj.payment_schedule_id = ps.payment_schedule_id
6681: and adj.adjustment_id = p_adj_id ;
6682: