[Home] [Help]
4768: IF PG_DEBUG in ('Y','C') THEN
4769: arp_standard.debug ( ' rows DELETED PS = ' || SQL%ROWCOUNT );
4770: END IF;
4771:
4772: delete from ar_distributions
4773: where source_table = 'CRH'
4774: and source_id in ( select cash_receipt_history_id
4775: from ar_cash_receipt_history
4776: where cash_receipt_id in ( select distinct cash_receipt_id
4780: IF PG_DEBUG in ('Y','C') THEN
4781: arp_standard.debug ( ' rows DELETED AR_DIST = ' || SQL%ROWCOUNT );
4782: END IF;
4783:
4784: delete from ar_distributions
4785: where source_table = 'RA'
4786: and source_id in ( select receivable_application_id
4787: from ar_receivable_applications
4788: where cash_receipt_id in ( select distinct cash_receipt_id