[Home] [Help]
341: p_sum_risk_rem_amt,
342: p_sum_risk_func_ori_amt,
343: p_sum_risk_func_rem_amt,
344: p_risk_count
345: from ar_cash_receipts cr,
346: ar_payment_schedules ps
347: where ps.customer_id = p_customer_id /* Bug 1963032 */
348: and ps.cash_receipt_id = cr.cash_receipt_id
349: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
404: p_sum_risk_rem_amt,
405: p_sum_risk_func_ori_amt,
406: p_sum_risk_func_rem_amt,
407: p_risk_count
408: from ar_cash_receipts cr,
409: ar_payment_schedules ps,
410: ar_cash_receipt_history crh
411: where ps.customer_id = p_customer_id /* Bug 1963032 */
412: and ps.cash_receipt_id = cr.cash_receipt_id
539: count(cr.amount)
540: INTO p_nsf_stop_amount,
541: p_nsf_stop_func_amt,
542: p_nsf_stop_count
543: FROM ar_cash_receipts cr,
544: ar_payment_schedules ps
545: WHERE ps.gl_date between p_start_date and p_end_date
546: AND ps.cash_receipt_id = cr.cash_receipt_id
547: AND cr.reversal_category in ('NSF','STOP')
775: into p_pend_confirm_amt,
776: p_pend_confirm_func_amt,
777: p_pend_confirm_count
778: from ar_payment_schedules ps,
779: ar_cash_receipts cr,
780: ar_cash_receipt_history crh
781: where ps.customer_id = p_customer_id /* bug1963032 */
782: and ps.cash_receipt_id = cr.cash_receipt_id
783: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id,
880: l_rem_amount,
881: l_func_ori_amt,
882: l_func_rem_amt,
883: l_count
884: from ar_cash_receipts cr,
885: ar_payment_schedules ps,
886: ar_cash_receipt_history crh,
887: ar_receipt_methods rm,
888: ar_receipt_classes rc
1025: l_rem_amount,
1026: l_func_ori_amt,
1027: l_func_rem_amt,
1028: l_count
1029: from ar_cash_receipts cr,
1030: ar_payment_schedules ps,
1031: ar_cash_receipt_history crh
1032: where ps.customer_id = p_customer_id /* bug1963032 */
1033: and ps.cash_receipt_id = cr.cash_receipt_id