APPS.OE_CREDIT_PUB dependencies on AR_CASH_RECEIPTS

Line 769: , AR_CASH_RECEIPTS CR

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'
773: AND CRH.STATUS <>

Line 783: , AR_CASH_RECEIPTS CR

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'
787: AND CRH.STATUS <>

Line 1008: , AR_CASH_RECEIPTS CR

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'
1012: AND CRH.STATUS <>

Line 1023: , AR_CASH_RECEIPTS CR

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'
1027: AND CRH.STATUS <>

Line 2450: AR_CASH_RECEIPTS CR

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'
2454: AND CRH.STATUS <> DECODE(CRH.FACTOR_FLAG,'Y',

Line 2463: , AR_CASH_RECEIPTS CR

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'
2467: AND CRH.STATUS <>

Line 2712: , AR_CASH_RECEIPTS CR

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'
2716: AND CRH.STATUS <>

Line 2727: , AR_CASH_RECEIPTS CR

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'
2731: AND CRH.STATUS <>