APPS.OE_CREDIT_PUB dependencies on AR_CASH_RECEIPT_HISTORY

Line 768: FROM AR_CASH_RECEIPT_HISTORY CRH

764: AND SYSDATE - TRX_DATE > l_open_ar_days;
765:
766: Cursor pay_risk IS
767: SELECT NVL(SUM(CRH.AMOUNT), 0)
768: FROM AR_CASH_RECEIPT_HISTORY CRH
769: , AR_CASH_RECEIPTS CR
770: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
771: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
772: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 782: FROM AR_CASH_RECEIPT_HISTORY CRH

778: AND CR.PAY_FROM_CUSTOMER = l_invoice_to_cust_id;
779:
780: Cursor pay_risk_in_ar_days IS
781: SELECT NVL(SUM(CRH.AMOUNT), 0)
782: FROM AR_CASH_RECEIPT_HISTORY CRH
783: , AR_CASH_RECEIPTS CR
784: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
785: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
786: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 1007: FROM AR_CASH_RECEIPT_HISTORY CRH

1003: AND SYSDATE - TRX_DATE > l_open_ar_days;
1004:
1005: Cursor site_pay_risk IS
1006: SELECT NVL(SUM(CRH.AMOUNT),0)
1007: FROM AR_CASH_RECEIPT_HISTORY CRH
1008: , AR_CASH_RECEIPTS CR
1009: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1010: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
1011: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 1022: FROM AR_CASH_RECEIPT_HISTORY CRH

1018: AND CR.CUSTOMER_SITE_USE_ID = p_header_rec.invoice_to_org_id;
1019:
1020: Cursor site_pay_risk_in_ar_days IS
1021: SELECT NVL(SUM(CRH.AMOUNT),0)
1022: FROM AR_CASH_RECEIPT_HISTORY CRH
1023: , AR_CASH_RECEIPTS CR
1024: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
1025: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
1026: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 2449: FROM AR_CASH_RECEIPT_HISTORY CRH,

2445: AND SYSDATE - TRX_DATE > l_open_ar_days;
2446:
2447: Cursor pay_risk IS
2448: SELECT NVL(SUM(CRH.AMOUNT), 0)
2449: FROM AR_CASH_RECEIPT_HISTORY CRH,
2450: AR_CASH_RECEIPTS CR
2451: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
2452: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
2453: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 2462: FROM AR_CASH_RECEIPT_HISTORY CRH

2458: AND CR.PAY_FROM_CUSTOMER = p_customer_id;
2459:
2460: Cursor pay_risk_in_ar_days IS
2461: SELECT NVL(SUM(CRH.AMOUNT), 0)
2462: FROM AR_CASH_RECEIPT_HISTORY CRH
2463: , AR_CASH_RECEIPTS CR
2464: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
2465: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
2466: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 2711: FROM AR_CASH_RECEIPT_HISTORY CRH

2707: AND SYSDATE - TRX_DATE > l_open_ar_days;
2708:
2709: Cursor site_pay_risk IS
2710: SELECT NVL(SUM(CRH.AMOUNT),0)
2711: FROM AR_CASH_RECEIPT_HISTORY CRH
2712: , AR_CASH_RECEIPTS CR
2713: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
2714: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
2715: AND CRH.CURRENT_RECORD_FLAG = 'Y'

Line 2726: FROM AR_CASH_RECEIPT_HISTORY CRH

2722: AND CR.CUSTOMER_SITE_USE_ID = p_invoice_to_org_id;
2723:
2724: Cursor site_pay_risk_in_ar_days IS
2725: SELECT NVL(SUM(CRH.AMOUNT),0)
2726: FROM AR_CASH_RECEIPT_HISTORY CRH
2727: , AR_CASH_RECEIPTS CR
2728: WHERE CRH.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
2729: AND NVL(CR.CONFIRMED_FLAG,'Y') = 'Y'
2730: AND CRH.CURRENT_RECORD_FLAG = 'Y'