APPS.AR_UNACCOUNTED_TRX_SWEEP dependencies on AR_MISC_CASH_DISTRIBUTIONS_ALL

Line 101: UPDATE ar_misc_cash_distributions_all

97:
98: arp_standard.debug ('update_ar_acct_date: total records updated in ar_receivable_applications_all: '||sql%rowcount);
99:
100: <>
101: UPDATE ar_misc_cash_distributions_all
102: SET gl_date = g_sweep_to_date,
103: program_id = ln_conc_program_id,
104: last_update_date = sysdate,
105: last_updated_by = FND_GLOBAL.user_id

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

110: AND EXISTS
111: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
112: AND posting_control_id = -3;
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,

Line 1051: , ar_misc_cash_distributions_all mcd

1047: , cr.pay_from_customer
1048: , null
1049: , null
1050: FROM ar_cash_receipts_all cr
1051: , ar_misc_cash_distributions_all mcd
1052: , xla_events xle
1053: , ar_distributions_all ard
1054: WHERE cr.cash_receipt_id = mcd.cash_receipt_id
1055: and cr.set_of_books_id = g_ledger_id