APPS.ARP_CASH_BASIS_JE_REPORT dependencies on AR_ADJUSTMENTS

Line 341: FROM ar_adjustments a,

337: a.amount
338: ) amount,
339: a.code_combination_id ccid,
340: substrb(a.type,1,15) accntclass
341: FROM ar_adjustments a,
342: ra_customer_trx ct,
343: ra_cust_trx_types ctt
344: WHERE a.payment_schedule_id = cp_ps_id
345: AND a.receivables_trx_id <> -1

Line 459: FROM ar_adjustments

455: IF ( p_type = 'CHARGES' ) AND ( l_TotalAmount <> 0 )
456: THEN
457: SELECT nvl(sum(nvl(receivables_charges_adjusted,0)),0)
458: INTO charges_adjusted
459: FROM ar_adjustments
460: WHERE payment_schedule_id = p_ps_id
461: AND status = 'A'
462: AND type in ('INVOICE','CHARGES');
463: