APPS.ARP_BALANCE_CHECK dependencies on AR_ADJUSTMENTS

Line 584: from ar_adjustments

580: sum(nvl(acctd_amount_dr,0)), sum(nvl(acctd_amount_cr,0))
581: into l_amt_dr, l_amt_cr, l_acctd_amt_dr, l_acctd_amt_cr
582: from (select adjustment_id src_id,
583: 'ADJ' src_tab
584: from ar_adjustments
585: where adjustment_id = p_adj_id
586: and nvl(postable,'Y') = 'Y'
587: and posting_control_id = -3) src,
588: ar_distributions ard

Line 615: from ar_adjustments

611: select nvl(amount,0), nvl(line_adjusted,0)+nvl(tax_adjusted,0)+
612: nvl(freight_adjusted,0)+nvl(receivables_charges_adjusted,0),
613: status
614: into l_amount, l_calc_amount,l_status
615: from ar_adjustments
616: where adjustment_id = p_adj_id;
617:
618: IF l_amount <> l_calc_amount AND l_status = 'A' THEN
619: IF p_called_from_api = 'Y' THEN

Line 1100: FROM ar_adjustments adj

1096: WHERE status = 'APP'
1097: AND ra.applied_payment_schedule_id = p_ps_rec.payment_schedule_id
1098: UNION ALL
1099: SELECT MAX(apply_date) apply_date
1100: FROM ar_adjustments adj
1101: WHERE status = 'A'
1102: AND adj.payment_schedule_id = p_ps_rec.payment_schedule_id
1103: );
1104: ELSE

Line 1144: FROM ar_adjustments adj

1140: WHERE status = 'APP'
1141: AND ra.applied_payment_schedule_id = p_ps_rec.payment_schedule_id
1142: UNION ALL
1143: SELECT MAX(gl_date) gl_date
1144: FROM ar_adjustments adj
1145: WHERE status = 'A'
1146: AND adj.payment_schedule_id = p_ps_rec.payment_schedule_id
1147: );
1148: ELSE