APPS.ARP_PROCESS_RCTS dependencies on AR_DISTRIBUTIONS

Line 297: from ar_distributions ard

293: from ar_receivable_applications app
294: where app.cash_receipt_id = p_cash_receipt_id
295: and nvl(app.confirmed_flag,'Y') = 'Y' --confirmed records have accounting only
296: and exists (select 'x'
297: from ar_distributions ard
298: where ard.source_table = 'RA'
299: and ard.source_id = app.receivable_application_id)
300: order by decode(app.status,
301: 'UNAPP',1, --Delete UNAPP related accounting first as record may be paired

Line 388: -- delete AR_DISTRIBUTIONS records created for each

384: END LOOP;
385:
386: arp_cash_receipts_pkg.delete_p(p_cash_receipt_id);
387:
388: -- delete AR_DISTRIBUTIONS records created for each
389: -- AR_CASH_RECEIPT_HISTORY record.
390:
391: DELETE AR_DISTRIBUTIONS
392: WHERE source_table = 'CRH'

Line 391: DELETE AR_DISTRIBUTIONS

387:
388: -- delete AR_DISTRIBUTIONS records created for each
389: -- AR_CASH_RECEIPT_HISTORY record.
390:
391: DELETE AR_DISTRIBUTIONS
392: WHERE source_table = 'CRH'
393: AND source_id IN (
394: SELECT cash_receipt_history_id
395: FROM ar_cash_receipt_history

Line 408: p_table_name => 'AR_DISTRIBUTIONS',

404: +---------------------------------*/
405:
406: ar_mrc_engine.maintain_mrc_data(
407: p_event_mode => 'DELETE',
408: p_table_name => 'AR_DISTRIBUTIONS',
409: p_mode => 'BATCH',
410: p_key_value_list => l_ar_dist_key_value_list);
411:
412: