APPS.ARP_ARXVASUM2 dependencies on AR_RECEIVABLE_APPLICATIONS

Line 424: from ar_receivable_applications rap

420: 'N', 'CLEARED'), 'REVERSED')
421: /* 06-AUG-2000 J Rautiainen BR Implementation
422: * Short term debt applications are not considered as receipts at risk */
423: and not exists (select 'X'
424: from ar_receivable_applications rap
425: where rap.cash_receipt_id = cr.cash_receipt_id
426: and rap.applied_payment_schedule_id = -2
427: and rap.display = 'Y');
428:

Line 490: from ar_receivable_applications ra,

486: p_payments_late_amount,
487: p_payments_ontime_amount,
488: p_payments_late_func_amt,
489: p_payments_ontime_func_amt
490: from ar_receivable_applications ra,
491: ar_payment_schedules ps
492: where ra.applied_payment_schedule_id = ps.payment_schedule_id
493: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
494: AND ra.apply_date between p_start_date and p_end_date

Line 722: FROM ar_receivable_applications ra,

718: p_earned_func_disc,
719: p_unearned_func_disc,
720: p_earned_disc_count,
721: p_unearned_disc_count
722: FROM ar_receivable_applications ra,
723: ar_payment_schedules ps
724: where ra.gl_date between p_start_date and p_end_date
725: and ps.payment_schedule_id = ra.applied_payment_schedule_id
726: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )