APPS.IGIRCBAP dependencies on AR_ADJUSTMENTS

Line 391: FROM ar_adjustments a,

387: a.amount
388: ) amount,
389: a.code_combination_id ccid,
390: substrb(a.type,1,15) accntclass
391: FROM ar_adjustments a,
392: ra_customer_trx ct,
393: ra_cust_trx_types ctt
394: WHERE a.payment_schedule_id = cp_ps_id
395: AND a.receivables_trx_id <> -1

Line 489: FROM ar_adjustments

485: THEN
486:
487: SELECT nvl(sum(nvl(receivables_charges_adjusted,0)),0)
488: INTO charges_adjusted
489: FROM ar_adjustments
490: WHERE payment_schedule_id = p_ps_id
491: AND status = 'A'
492: AND type in ('INVOICE','CHARGES');
493:

Line 2343: FROM ar_adjustments adj

2339: and igimcd.arc_posting_control_id = p_PostingControlId;
2340:
2341: SELECT nvl(max(adj.adjustment_id), 999999999999998)+1
2342: INTO l_Post.NxtAdjustmentId
2343: FROM ar_adjustments adj
2344: , igi_ar_adjustments igiadj
2345: WHERE adj.adjustment_id = igiadj.adjustment_id
2346: AND igiadj.arc_posting_control_id = p_PostingControlId;
2347:

Line 2344: , igi_ar_adjustments igiadj

2340:
2341: SELECT nvl(max(adj.adjustment_id), 999999999999998)+1
2342: INTO l_Post.NxtAdjustmentId
2343: FROM ar_adjustments adj
2344: , igi_ar_adjustments igiadj
2345: WHERE adj.adjustment_id = igiadj.adjustment_id
2346: AND igiadj.arc_posting_control_id = p_PostingControlId;
2347:
2348: SELECT nvl(max(cust_trx_line_gl_dist_id), 999999999999998)+1