APPS.ARP_ARXVASUM2 dependencies on AR_CASH_RECEIPT_HISTORY

Line 408: ar_cash_receipt_history crh

404: p_sum_risk_func_rem_amt,
405: p_risk_count
406: from ar_cash_receipts cr,
407: ar_payment_schedules ps,
408: ar_cash_receipt_history crh
409: where ps.cash_receipt_id = cr.cash_receipt_id
410: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
411: and ps.gl_date between p_start_date and p_end_date
412: and ps.invoice_currency_code = nvl(p_currency_code,ps.invoice_currency_code)

Line 772: ar_cash_receipt_history crh

768: p_pend_confirm_func_amt,
769: p_pend_confirm_count
770: from ar_payment_schedules ps,
771: ar_cash_receipts cr,
772: ar_cash_receipt_history crh
773: where ps.cash_receipt_id = cr.cash_receipt_id
774: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id,
775: -10) )
776: and ps.gl_date between p_start_date and p_end_date

Line 877: ar_cash_receipt_history crh,

873: l_func_rem_amt,
874: l_count
875: from ar_cash_receipts cr,
876: ar_payment_schedules ps,
877: ar_cash_receipt_history crh,
878: ar_receipt_methods rm,
879: ar_receipt_classes rc
880: where ps.cash_receipt_id = cr.cash_receipt_id
881: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )

Line 1021: ar_cash_receipt_history crh

1017: l_func_rem_amt,
1018: l_count
1019: from ar_cash_receipts cr,
1020: ar_payment_schedules ps,
1021: ar_cash_receipt_history crh
1022: where ps.cash_receipt_id = cr.cash_receipt_id
1023: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
1024: and ps.gl_date between p_start_date and p_end_date
1025: and ps.invoice_currency_code = nvl(p_currency_code,ps.invoice_currency_code)