APPS.ARP_ARXVASUM dependencies on AR_RECEIVABLE_APPLICATIONS

Line 427: from ar_receivable_applications rap

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

Line 493: from ar_receivable_applications ra,

489: p_payments_late_amount,
490: p_payments_ontime_amount,
491: p_payments_late_func_amt,
492: p_payments_ontime_func_amt
493: from ar_receivable_applications ra,
494: ar_payment_schedules ps
495: where ra.applied_payment_schedule_id = ps.payment_schedule_id
496: and ps.customer_id = p_customer_id /* bug1963032 */
497: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )

Line 729: FROM ar_receivable_applications ra,

725: p_earned_func_disc,
726: p_unearned_func_disc,
727: p_earned_disc_count,
728: p_unearned_disc_count
729: FROM ar_receivable_applications ra,
730: ar_payment_schedules ps
731: where ra.gl_date between p_start_date and p_end_date
732: and ps.payment_schedule_id = ra.applied_payment_schedule_id
733: and ps.customer_id = p_customer_id /* bug1963032 */