APPS.OE_CREDIT_PUB dependencies on AR_CASH_RECEIPT_HISTORY

Line 750: FROM AR_CASH_RECEIPT_HISTORY CRH

746: AND SYSDATE - TRX_DATE > l_open_ar_days;
747:
748: Cursor pay_risk IS
749: SELECT NVL(SUM(CRH.AMOUNT), 0)
750: FROM AR_CASH_RECEIPT_HISTORY CRH
751: , AR_CASH_RECEIPTS CR
752: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
753: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
754: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 764: FROM AR_CASH_RECEIPT_HISTORY CRH

760: AND CR.PAY_FROM_CUSTOMER = l_invoice_to_cust_id;
761:
762: Cursor pay_risk_in_ar_days IS
763: SELECT NVL(SUM(CRH.AMOUNT), 0)
764: FROM AR_CASH_RECEIPT_HISTORY CRH
765: , AR_CASH_RECEIPTS CR
766: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
767: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
768: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 989: FROM AR_CASH_RECEIPT_HISTORY CRH

985: AND SYSDATE - TRX_DATE > l_open_ar_days;
986:
987: Cursor site_pay_risk IS
988: SELECT NVL(SUM(CRH.AMOUNT),0)
989: FROM AR_CASH_RECEIPT_HISTORY CRH
990: , AR_CASH_RECEIPTS CR
991: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
992: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
993: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 1004: FROM AR_CASH_RECEIPT_HISTORY CRH

1000: AND CR.CUSTOMER_SITE_USE_ID = p_header_rec.invoice_to_org_id;
1001:
1002: Cursor site_pay_risk_in_ar_days IS
1003: SELECT NVL(SUM(CRH.AMOUNT),0)
1004: FROM AR_CASH_RECEIPT_HISTORY CRH
1005: , AR_CASH_RECEIPTS CR
1006: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1007: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
1008: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 2413: FROM AR_CASH_RECEIPT_HISTORY CRH,

2409: AND SYSDATE - TRX_DATE > l_open_ar_days;
2410:
2411: Cursor pay_risk IS
2412: SELECT NVL(SUM(CRH.AMOUNT), 0)
2413: FROM AR_CASH_RECEIPT_HISTORY CRH,
2414: AR_CASH_RECEIPTS CR
2415: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
2416: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
2417: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 2426: FROM AR_CASH_RECEIPT_HISTORY CRH

2422: AND CR.PAY_FROM_CUSTOMER = p_customer_id;
2423:
2424: Cursor pay_risk_in_ar_days IS
2425: SELECT NVL(SUM(CRH.AMOUNT), 0)
2426: FROM AR_CASH_RECEIPT_HISTORY CRH
2427: , AR_CASH_RECEIPTS CR
2428: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
2429: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
2430: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 2675: FROM AR_CASH_RECEIPT_HISTORY CRH

2671: AND SYSDATE - TRX_DATE > l_open_ar_days;
2672:
2673: Cursor site_pay_risk IS
2674: SELECT NVL(SUM(CRH.AMOUNT),0)
2675: FROM AR_CASH_RECEIPT_HISTORY CRH
2676: , AR_CASH_RECEIPTS CR
2677: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
2678: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
2679: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 2690: FROM AR_CASH_RECEIPT_HISTORY CRH

2686: AND CR.CUSTOMER_SITE_USE_ID = p_invoice_to_org_id;
2687:
2688: Cursor site_pay_risk_in_ar_days IS
2689: SELECT NVL(SUM(CRH.AMOUNT),0)
2690: FROM AR_CASH_RECEIPT_HISTORY CRH
2691: , AR_CASH_RECEIPTS CR
2692: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
2693: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
2694: AND CRH.CURRENT_RECORD_FLAG = 'Y'