APPS.ARP_BALANCE_CHECK dependencies on AR_ADJUSTMENTS

Line 338: from ar_adjustments

334: sum(nvl(acctd_amount_dr,0)), sum(nvl(acctd_amount_cr,0))
335: into l_amt_dr, l_amt_cr, l_acctd_amt_dr, l_acctd_amt_cr
336: from (select adjustment_id src_id,
337: 'ADJ' src_tab
338: from ar_adjustments
339: where adjustment_id = p_adj_id
340: and nvl(postable,'Y') = 'Y'
341: and posting_control_id = -3) src,
342: ar_distributions ard

Line 368: from ar_adjustments

364: select nvl(amount,0), nvl(line_adjusted,0)+nvl(tax_adjusted,0)+
365: nvl(freight_adjusted,0)+nvl(receivables_charges_adjusted,0),
366: status
367: into l_amount, l_calc_amount,l_status
368: from ar_adjustments
369: where adjustment_id = p_adj_id;
370:
371: IF l_amount <> l_calc_amount AND l_status = 'A' THEN
372: IF p_called_from_api = 'Y' THEN