APPS.ARP_PROCESS_ADJUSTMENT dependencies on AR_DISTRIBUTIONS

Line 489: FROM ar_distributions ard,

485: ard.ref_customer_trx_line_id,
486: ard.ref_account_class,
487: ard.activity_bucket,
488: ctl.line_type
489: FROM ar_distributions ard,
490: ra_customer_trx_lines ctl
491: WHERE ctl.customer_trx_id = p_customer_trx_id
492: AND ctl.customer_trx_line_id = ard.ref_customer_trx_line_id
493: AND (ctl.customer_trx_line_id = p_customer_trx_line_id

Line 2289: from ar_distributions

2285: If the updated record is an adjustment reversal, the accounting
2286: entries should not be changed */
2287: select count(*)
2288: into l_accounts
2289: from ar_distributions
2290: where source_id = p_adjustment_id
2291: and source_table = 'ADJ';
2292: IF l_adj_rec.receivables_trx_id = -13 AND l_accounts > 0 THEN
2293: l_recreate_accounting := FALSE;