APPS.ARP_CASH_BASIS_ACCOUNTING dependencies on AR_ADJUSTMENTS

Line 481: FROM ar_adjustments a,

477: a.amount
478: ) amount,
479: a.code_combination_id ccid,
480: substrb(a.type,1,15) accntclass
481: FROM ar_adjustments a,
482: ra_customer_trx ct,
483: ra_cust_trx_types ctt
484: WHERE a.payment_schedule_id = cp_ps_id
485: AND a.receivables_trx_id <> -1

Line 577: FROM ar_adjustments

573: IF ( p_type = 'CHARGES' ) AND ( l_TotalAmount <> 0 )
574: THEN
575: SELECT nvl(sum(nvl(receivables_charges_adjusted,0)),0)
576: INTO charges_adjusted
577: FROM ar_adjustments
578: WHERE payment_schedule_id = p_ps_id
579: AND status = 'A'
580: AND type in ('INVOICE','CHARGES');
581: