APPS.AR_BUS_EVENT_SUB_PVT dependencies on AR_ADJUSTMENTS

Line 6325: FROM ar_adjustments adj,

6321: SELECT sum(amount),count(adj.adjustment_id) adj_count,
6322: ps.customer_id, ps.customer_site_use_id,
6323: ps.invoice_currency_code, adj.apply_date,
6324: ps.class, ps.due_date, adj.status
6325: FROM ar_adjustments adj,
6326: ar_payment_schedules ps
6327: WHERE adj.request_id = p_req_id
6328: and adj.payment_schedule_id = ps.payment_schedule_id
6329: group by ps.customer_id,

Line 6549: FROM ar_adjustments adj,

6545: CURSOR get_adj_details (p_adj_id IN NUMBER) IS
6546: SELECT adj.amount, adj.apply_date, adj.receivables_trx_id,
6547: ps.customer_id, ps.customer_site_use_id, ps.invoice_currency_code,
6548: ps.class, ps.due_date
6549: FROM ar_adjustments adj,
6550: ar_payment_schedules ps
6551: WHERE adj.payment_schedule_id = ps.payment_schedule_id
6552: and adj.adjustment_id = p_adj_id ;
6553: l_past_due_inv_inst_count NUMBER;

Line 6718: FROM ar_adjustments adj,

6714: CURSOR get_adj_details (p_adj_id IN NUMBER) IS
6715: SELECT adj.amount, adj.apply_date, adj.receivables_trx_id,
6716: ps.customer_id, ps.customer_site_use_id, ps.invoice_currency_code,
6717: ps.class, ps.due_date
6718: FROM ar_adjustments adj,
6719: ar_payment_schedules ps
6720: WHERE adj.payment_schedule_id = ps.payment_schedule_id
6721: and adj.adjustment_id = p_adj_id ;
6722: