APPS.IGIRCBJP dependencies on AR_ADJUSTMENTS

Line 356: FROM ar_adjustments a,

352: a.amount
353: ) amount,
354: a.code_combination_id ccid,
355: substrb(a.type,1,15) accntclass
356: FROM ar_adjustments a,
357: ra_customer_trx ct,
358: ra_cust_trx_types ctt
359: WHERE a.payment_schedule_id = cp_ps_id
360: AND a.receivables_trx_id <> -1

Line 474: FROM ar_adjustments

470: IF ( p_type = 'CHARGES' ) AND ( l_TotalAmount <> 0 )
471: THEN
472: SELECT nvl(sum(nvl(receivables_charges_adjusted,0)),0)
473: INTO charges_adjusted
474: FROM ar_adjustments
475: WHERE payment_schedule_id = p_ps_id
476: AND status = 'A'
477: AND type in ('INVOICE','CHARGES');
478:

Line 2654: , ar_adjustments_s.nextval

2650: --
2651: SELECT ar_cash_receipt_history_s.nextval
2652: , ar_receivable_applications_s.nextval
2653: , ar_misc_cash_distributions_s.nextval
2654: , ar_adjustments_s.nextval
2655: , ra_cust_trx_line_gl_dist_s.nextval
2656: INTO l_Report.NxtCashReceiptHistoryId
2657: , l_Report.NxtReceivableApplicationId
2658: , l_Report.NxtMiscCashDistributionId