APPS.OE_CREDIT_CHECK_UTIL dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 7860: FROM ar_cash_receipt_history_ALL crh

7856:
7857: /*CURSOR cust_pay_risk_global
7858: (p_curr_code IN VARCHAR2 default NULL) IS
7859: SELECT SUM(NVL(crh.amount,0))
7860: FROM ar_cash_receipt_history_ALL crh
7861: , ar_cash_receipts_ALL cr
7862: , hz_cust_site_uses_ALL su
7863: , hz_cust_acct_sites_ALL cas
7864: WHERE crh.cash_receipt_id = cr.cash_receipt_id

Line 7898: FROM ar_cash_receipt_history_ALL crh

7894: CURSOR cust_pay_risk_global
7895: (p_curr_code IN VARCHAR2 default NULL) IS
7896: SELECT SUM(NVL(amount,0)) FROM (
7897: SELECT NVL(crh.amount,0) amount,cr.pay_from_customer,cr.cash_receipt_id
7898: FROM ar_cash_receipt_history_ALL crh
7899: , ar_cash_receipts_ALL cr
7900: , hz_cust_site_uses_ALL su
7901: , hz_cust_acct_sites_ALL cas
7902: WHERE crh.cash_receipt_id = cr.cash_receipt_id

Line 7933: FROM ar_cash_receipt_history_ALL crh

7929: AND rap.display = 'Y'
7930: )
7931: UNION
7932: SELECT NVL(crh.amount,0) amount,cr.pay_from_customer,cr.cash_receipt_id
7933: FROM ar_cash_receipt_history_ALL crh
7934: , ar_cash_receipts_ALL cr
7935: WHERE crh.cash_receipt_id = cr.cash_receipt_id
7936: AND (cr.confirmed_flag IS NULL OR cr.confirmed_flag = 'Y')
7937: AND crh.current_record_flag = 'Y'

Line 7983: FROM ar_cash_receipt_history_ALL crh

7979:
7980: CURSOR cust_br_pay_risk_global
7981: (p_curr_code IN VARCHAR2 default NULL) IS
7982: SELECT SUM(NVL(crh.amount,0))
7983: FROM ar_cash_receipt_history_ALL crh
7984: , ar_cash_receipts_ALL cr
7985: , hz_cust_site_uses_ALL su
7986: , hz_cust_acct_sites_ALL cas
7987: WHERE crh.cash_receipt_id = cr.cash_receipt_id