APPS.AR_UNACCOUNTED_TRX_SWEEP dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 38: UPDATE ra_cust_trx_line_gl_dist_all

34: WHERE concurrent_program_name='ARTRXSWP';
35:
36:
37: <>
38: UPDATE ra_cust_trx_line_gl_dist_all
39: SET gl_date = g_sweep_to_date,
40: program_id = ln_conc_program_id,
41: last_update_date = sysdate,
42: last_updated_by = FND_GLOBAL.user_id

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

46: AND EXISTS
47: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
48: AND posting_control_id = -3;
49:
50: arp_standard.debug ('update_ar_acct_date: total records updated in ra_cust_trx_line_gl_dist_all: '||sql%rowcount);
51:
52: <>
53: UPDATE ar_receivable_applications_all
54: SET gl_date = g_sweep_to_date,

Line 154: from ra_cust_trx_line_gl_dist_all

150: -- TRX
151:
152: update ar_payment_schedules_all ps
153: set ps.gl_date = ( select nvl(min(gl_date), ps.gl_date)
154: from ra_cust_trx_line_gl_dist_all
155: where customer_trx_id = ps.customer_trx_id
156: and latest_rec_flag = 'Y'),
157: ps.gl_date_closed = decode(ps.status,
158: 'CL', (SELECT MAX(a.gl_date)

Line 190: from ra_cust_trx_line_gl_dist_all

186: WHERE EXISTS
187: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
188: and class not in ('PMT', 'BR')
189: and trunc(ps.gl_date) <> ( select nvl(min(gl_date), ps.gl_date)
190: from ra_cust_trx_line_gl_dist_all
191: where customer_trx_id = ps.customer_trx_id
192: and latest_rec_flag = 'Y'
193: );
194:

Line 654: ,ra_cust_trx_line_gl_dist_all gld

650: , ps.payment_schedule_id
651: , NULL
652: from
653: ra_customer_trx_all ct
654: ,ra_cust_trx_line_gl_dist_all gld
655: ,xla_events xle
656: ,ar_payment_schedules_all ps
657: WHERE ct.complete_flag = 'Y'
658: and ct.customer_trx_id = gld.customer_trx_id