APPS.ARP_PROCESS_MISC_RECEIPTS2 dependencies on AR_DISTRIBUTIONS

Line 275: -- There will be no 'MCD' records in ar_distributions for cash basis accounting

271: END IF;
272:
273: /************* begin bug5655154, commented and replaced with below code
274: -- Bug 2189383
275: -- There will be no 'MCD' records in ar_distributions for cash basis accounting
276:
277: IF l_accounting_method ='CASH' THEN
278: SELECT count(mcd.misc_cash_distribution_id)
279: INTO l_count

Line 292: FROM ar_distributions ard

288: WHERE mcd.cash_receipt_id = p_cash_receipt_id
289: AND mcd.reversal_gl_date IS NULL --For rate adjustments picks up records with new rate
290: AND mcd.posting_control_id = -3 --Not posted
291: AND EXISTS (SELECT 'x'
292: FROM ar_distributions ard
293: WHERE ard.source_id = mcd.misc_cash_distribution_id
294: AND ard.source_table = 'MCD');
295: END IF;
296: *********** end bug5655154 ******/

Line 306: FROM ar_distributions ard

302: WHERE mcd.cash_receipt_id = p_cash_receipt_id
303: AND mcd.reversal_gl_date IS NULL --For rate adjustments picks up records with new rate
304: AND mcd.posting_control_id = -3 --Not posted
305: AND EXISTS (SELECT 'x'
306: FROM ar_distributions ard
307: WHERE ard.source_id = mcd.misc_cash_distribution_id
308: AND ard.source_table = 'MCD');
309:
310: IF l_dist_cnt = 0 and l_accounting_method = 'CASH' THEN

Line 345: -- delete AR_DISTRIBUTIONS records created for each

341: -- delete AR_CASH_RECEIPTS receipt record:
342:
343: arp_cash_receipts_pkg.delete_p(p_cash_receipt_id);
344:
345: -- delete AR_DISTRIBUTIONS records created for each
346: -- AR_CASH_RECEIPT_HISTORY record.
347:
348: -- only delete when there is a AR_MIS_CASH_DISTRIBUTION
349: -- and AR_DISTRIBUTION record.

Line 362: DELETE AR_DISTRIBUTIONS

358: IF PG_DEBUG in ('Y', 'C') THEN
359: arp_standard.debug('delete_misc_receipt: ' || ' Delete AR_DISTRIBUTION');
360: END IF;
361:
362: DELETE AR_DISTRIBUTIONS
363: WHERE source_table = 'CRH'
364: AND source_id IN (
365: SELECT cash_receipt_history_id
366: FROM ar_cash_receipt_history

Line 378: p_table_name => 'AR_DISTRIBUTIONS',

374: +---------------------------------*/
375:
376: ar_mrc_engine.maintain_mrc_data(
377: p_event_mode => 'DELETE',
378: p_table_name => 'AR_DISTRIBUTIONS',
379: p_mode => 'BATCH',
380: p_key_value_list => l_ar_dist_key_value_list);
381:
382: -- delete all AR_MISC_CASH distributions records created for