APPS.AR_UNACCOUNTED_TRX_SWEEP dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 69: UPDATE ar_cash_receipt_history_all

65:
66: arp_standard.debug ('update_ar_acct_date: total records updated in ar_receivable_applications_all: '||sql%rowcount);
67:
68: <>
69: UPDATE ar_cash_receipt_history_all
70: SET gl_date = g_sweep_to_date,
71: program_id = ln_conc_program_id,
72: last_update_date = sysdate,
73: last_updated_by = FND_GLOBAL.user_id

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

78: AND EXISTS
79: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
80: AND posting_control_id = -3;
81:
82: arp_standard.debug ('update_ar_acct_date: total records updated in ar_cash_receipt_history_all: '||sql%rowcount);
83:
84: <>
85: UPDATE ar_receivable_applications_all
86: SET gl_date = g_sweep_to_date,

Line 257: from ar_cash_receipt_history_all

253: -- PMT
254:
255: update ar_payment_schedules_all ps
256: set ps.gl_date = ( select nvl(min(gl_date), ps.gl_date)
257: from ar_cash_receipt_history_all
258: where cash_receipt_id = ps.cash_receipt_id
259: and first_posted_record_flag = 'Y'),
260: ps.gl_date_closed = decode(ps.status,
261: 'CL', (SELECT MAX(a.gl_date)

Line 279: from ar_cash_receipt_history_all

275: WHERE EXISTS
276: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
277: and class = 'PMT'
278: and trunc(ps.gl_date) <> ( select nvl(min(gl_date), ps.gl_date)
279: from ar_cash_receipt_history_all
280: where cash_receipt_id = ps.cash_receipt_id
281: and first_posted_record_flag = 'Y'
282: );
283:

Line 817: , ar_cash_receipt_history_all crh

813: , cr.pay_from_customer
814: , ps.payment_schedule_id
815: , null
816: FROM ar_cash_receipts_all cr
817: , ar_cash_receipt_history_all crh
818: , xla_events xle
819: , ar_distributions_all ard
820: , ar_payment_schedules_all ps
821: WHERE cr.cash_receipt_id = crh.cash_receipt_id

Line 895: , ar_cash_receipt_history_all crh

891: , cr.pay_from_customer
892: , null
893: , null
894: FROM ar_cash_receipts_all cr
895: , ar_cash_receipt_history_all crh
896: , xla_events xle
897: , ar_distributions_all ard
898: WHERE cr.type = 'MISC'
899: and cr.cash_receipt_id = crh.cash_receipt_id

Line 1275: FROM ar_period_close_excps_gt pce, ar_cash_receipt_history_all crh

1271: AND ra.gl_date between pce.gl_date and g_period_end_date
1272: AND ra.posting_control_id <> -3
1273: UNION
1274: SELECT pce.customer_trx_id
1275: FROM ar_period_close_excps_gt pce, ar_cash_receipt_history_all crh
1276: WHERE pce.document_type = G_SRC_TYP_UNACCT_RCT
1277: AND crh.cash_receipt_history_id = pce.dist_source_id
1278: AND pce.dist_source_table = 'CRH'
1279: AND crh.gl_date between pce.gl_date and g_period_end_date