APPS.OE_CREDIT_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 42: from AR_PAYMENT_SCHEDULES

38: -- Default to Y, in case there is one or more invoices due.
39: p_check_past_due := 'Y';
40: select 'Any Past due invoice'
41: into l_dummy
42: from AR_PAYMENT_SCHEDULES
43: WHERE CUSTOMER_ID = ( SELECT CUSTOMER_ID
44: FROM OE_INVOICE_TO_ORGS_V
45: WHERE ORGANIZATION_ID = p_header_rec.invoice_to_org_id)
46: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code

Line 753: FROM AR_PAYMENT_SCHEDULES

749: WHERE CREDIT_CHECK_RULE_ID = p_credit_check_rule_id;
750:
751: Cursor ar_balance IS
752: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
753: FROM AR_PAYMENT_SCHEDULES
754: WHERE CUSTOMER_ID = l_invoice_to_cust_id
755: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
756: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
757:

Line 760: FROM AR_PAYMENT_SCHEDULES

756: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
757:
758: Cursor ar_balance_in_ar_days IS
759: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
760: FROM AR_PAYMENT_SCHEDULES
761: WHERE CUSTOMER_ID = l_invoice_to_cust_id
762: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
763: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y'
764: AND SYSDATE - TRX_DATE > l_open_ar_days;

Line 992: FROM AR_PAYMENT_SCHEDULES

988:
989: -- CURSORS FOR SITE - LEVEL EXPOSURE CALCULATIONS
990: Cursor site_ar_balance IS
991: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
992: FROM AR_PAYMENT_SCHEDULES
993: WHERE CUSTOMER_SITE_USE_ID = p_header_rec.invoice_to_org_id
994: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
995: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
996:

Line 999: FROM AR_PAYMENT_SCHEDULES

995: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
996:
997: Cursor site_ar_balance_in_ar_days IS
998: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
999: FROM AR_PAYMENT_SCHEDULES
1000: WHERE CUSTOMER_SITE_USE_ID = p_header_rec.invoice_to_org_id
1001: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
1002: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y'
1003: AND SYSDATE - TRX_DATE > l_open_ar_days;

Line 1688: from AR_PAYMENT_SCHEDULES

1684: -- Default to Y, in case there is one or more invoices due.
1685: p_check_past_due := 'Y';
1686: select 'Any Past due invoice'
1687: into l_dummy
1688: from AR_PAYMENT_SCHEDULES
1689: WHERE CUSTOMER_ID = p_customer_id
1690: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
1691: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y'
1692: AND AMOUNT_DUE_REMAINING > 0

Line 2434: FROM AR_PAYMENT_SCHEDULES

2430: WHERE CREDIT_CHECK_RULE_ID = p_credit_check_rule_id;
2431:
2432: Cursor ar_balance IS
2433: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
2434: FROM AR_PAYMENT_SCHEDULES
2435: WHERE CUSTOMER_ID = p_customer_id
2436: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
2437: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
2438:

Line 2441: FROM AR_PAYMENT_SCHEDULES

2437: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
2438:
2439: Cursor ar_balance_in_ar_days IS
2440: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
2441: FROM AR_PAYMENT_SCHEDULES
2442: WHERE CUSTOMER_ID = p_customer_id
2443: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
2444: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y'
2445: AND SYSDATE - TRX_DATE > l_open_ar_days;

Line 2696: FROM AR_PAYMENT_SCHEDULES

2692:
2693: -- CURSORS FOR SITE - LEVEL EXPOSURE CALCULATIONS
2694: Cursor site_ar_balance IS
2695: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
2696: FROM AR_PAYMENT_SCHEDULES
2697: WHERE CUSTOMER_SITE_USE_ID = p_invoice_to_org_id
2698: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
2699: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
2700:

Line 2703: FROM AR_PAYMENT_SCHEDULES

2699: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
2700:
2701: Cursor site_ar_balance_in_ar_days IS
2702: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
2703: FROM AR_PAYMENT_SCHEDULES
2704: WHERE CUSTOMER_SITE_USE_ID = p_invoice_to_org_id
2705: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
2706: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y'
2707: AND SYSDATE - TRX_DATE > l_open_ar_days;