APPS.AR_UNACCOUNTED_TRX_SWEEP dependencies on AR_ADJUSTMENTS_ALL

Line 117: UPDATE ar_adjustments_all

113:
114: arp_standard.debug ('update_ar_acct_date: total records updated in ar_misc_cash_distributions_all: '||sql%rowcount);
115:
116: <>
117: UPDATE ar_adjustments_all
118: SET gl_date = g_sweep_to_date,
119: program_id = ln_conc_program_id,
120: last_update_date = sysdate,
121: last_updated_by = FND_GLOBAL.user_id

Line 130: arp_standard.debug ('update_ar_acct_date: total records updated in ar_adjustments_all: '||sql%rowcount);

126: AND EXISTS
127: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
128: AND posting_control_id = -3;
129:
130: arp_standard.debug ('update_ar_acct_date: total records updated in ar_adjustments_all: '||sql%rowcount);
131:
132: <>
133: UPDATE ar_transaction_history_all
134: SET gl_date = g_sweep_to_date,

Line 173: from ar_adjustments_all adj, ar_period_close_excps_gt psi

169: and ra.applied_payment_schedule_id = psi.payment_schedule_id
170: group by psi.payment_schedule_id
171: union all
172: select psi.payment_schedule_id payment_schedule_id, max(adj.gl_date) gl_date
173: from ar_adjustments_all adj, ar_period_close_excps_gt psi
174: where adj.status = 'A'
175: and adj.amount <> 0
176: and adj.payment_schedule_id = psi.payment_schedule_id
177: group by psi.payment_schedule_id

Line 241: from ar_adjustments_all adji, ar_period_close_excps_gt gt

237: AND EXISTS
238: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id)
239: union
240: select adji.payment_schedule_id
241: from ar_adjustments_all adji, ar_period_close_excps_gt gt
242: where adji.payment_schedule_id = gt.payment_schedule_id
243: and adji.adjustment_id = gt.adjustment_id
244: and gt.document_type = G_SRC_TYP_UNACCT_ADJ
245: and gt.dist_source_table = 'ADJ'

Line 307: from ar_adjustments_all adj, ar_period_close_excps_gt psi

303: and ra.applied_payment_schedule_id = psi.payment_schedule_id
304: group by psi.payment_schedule_id
305: union all
306: select psi.payment_schedule_id payment_schedule_id, max(adj.gl_date) gl_date
307: from ar_adjustments_all adj, ar_period_close_excps_gt psi
308: where adj.status = 'A'
309: and adj.amount <> 0
310: and adj.payment_schedule_id = psi.payment_schedule_id
311: group by psi.payment_schedule_id

Line 1130: FROM ar_adjustments_all adj

1126: , ct.invoice_currency_code
1127: , ct.bill_to_customer_id
1128: , ps.payment_schedule_id
1129: , null
1130: FROM ar_adjustments_all adj
1131: , ar_distributions_all ard
1132: , xla_events xle
1133: , ra_customer_trx_all ct
1134: , ar_payment_schedules_all ps