[Home] [Help]
340: p_sum_risk_rem_amt,
341: p_sum_risk_func_ori_amt,
342: p_sum_risk_func_rem_amt,
343: p_risk_count
344: from ar_cash_receipts cr,
345: ar_payment_schedules ps
346: where ps.cash_receipt_id = cr.cash_receipt_id
347: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
348: and ps.gl_date between p_start_date and p_end_date
402: p_sum_risk_rem_amt,
403: p_sum_risk_func_ori_amt,
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) )
535: count(cr.amount)
536: INTO p_nsf_stop_amount,
537: p_nsf_stop_func_amt,
538: p_nsf_stop_count
539: FROM ar_cash_receipts cr,
540: ar_payment_schedules ps
541: WHERE ps.gl_date between p_start_date and p_end_date
542: AND ps.cash_receipt_id = cr.cash_receipt_id
543: AND cr.reversal_category in ('NSF','STOP')
767: into p_pend_confirm_amt,
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) )
871: l_rem_amount,
872: l_func_ori_amt,
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
1015: l_rem_amount,
1016: l_func_ori_amt,
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) )