APPS.ARP_ACCT_MAIN dependencies on AR_CASH_BASIS_DISTS_ALL

Line 71: FROM AR_CASH_BASIS_DISTS_ALL

67: WHERE source_table = 'RA'
68: AND source_id = ra.receivable_application_id
69: )
70: AND EXISTS (SELECT 1
71: FROM AR_CASH_BASIS_DISTS_ALL
72: WHERE receivable_application_id = ra.receivable_application_id)
73: order by ra.cash_receipt_id, ra.receivable_application_id;
74:
75: l_replace_default_processing BOOLEAN := FALSE;

Line 156: FROM AR_CASH_BASIS_DISTS_ALL

152: Select count(*)
153: INTO l_amount_flag
154: FROM
155: (SELECT sum(nvl(amount, 0)) amount
156: FROM AR_CASH_BASIS_DISTS_ALL
157: WHERE receivable_application_id = l_miss_rec_app.receivable_application_id) a,
158: (Select sum(nvl(AMOUNT_CR, 0) - nvl(AMOUNT_DR, 0)) amount
159: FROM ar_distributions
160: WHERE source_table = 'RA'