APPS.ARP_ADJUSTMENTS_MAIN dependencies on RA_CUSTOMER_TRX_LINES

Line 806: UPDATE ra_customer_trx_lines

802:
803: --{3377004
804: IF l_index <> 0 THEN
805: FORALL m IN l_ctl_rem_amt.customer_trx_line_id.FIRST .. l_ctl_rem_amt.customer_trx_line_id.LAST
806: UPDATE ra_customer_trx_lines
807: SET AMOUNT_DUE_REMAINING = AMOUNT_DUE_REMAINING + l_ctl_rem_amt.amount_due_remaining(m),
808: ACCTD_AMOUNT_DUE_REMAINING = ACCTD_AMOUNT_DUE_REMAINING + l_ctl_rem_amt.acctd_amount_due_remaining(m),
809: CHRG_AMOUNT_REMAINING = CHRG_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_amount_remaining(m),
810: CHRG_ACCTD_AMOUNT_REMAINING = CHRG_ACCTD_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_acctd_amount_remaining(m)

Line 1743: FROM ra_customer_trx_lines ctl,

1739: min(decode(alv.location_segment_id,
1740: '',avt.adj_non_rec_tax_ccid,
1741: alv.adj_non_rec_tax_ccid))
1742: into l_code_combination_id
1743: FROM ra_customer_trx_lines ctl,
1744: ar_vat_tax avt,
1745: ar_location_accounts alv
1746: where ctl.customer_trx_id = p_adj_rec.customer_trx_id
1747: and ctl.line_type = 'TAX'