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 735: FROM AR_PAYMENT_SCHEDULES

731: WHERE CREDIT_CHECK_RULE_ID = p_credit_check_rule_id;
732:
733: Cursor ar_balance IS
734: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
735: FROM AR_PAYMENT_SCHEDULES
736: WHERE CUSTOMER_ID = l_invoice_to_cust_id
737: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
738: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
739:

Line 742: FROM AR_PAYMENT_SCHEDULES

738: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
739:
740: Cursor ar_balance_in_ar_days IS
741: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
742: FROM AR_PAYMENT_SCHEDULES
743: WHERE CUSTOMER_ID = l_invoice_to_cust_id
744: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
745: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y'
746: AND SYSDATE - TRX_DATE > l_open_ar_days;

Line 974: FROM AR_PAYMENT_SCHEDULES

970:
971: -- CURSORS FOR SITE - LEVEL EXPOSURE CALCULATIONS
972: Cursor site_ar_balance IS
973: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
974: FROM AR_PAYMENT_SCHEDULES
975: WHERE CUSTOMER_SITE_USE_ID = p_header_rec.invoice_to_org_id
976: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
977: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
978:

Line 981: FROM AR_PAYMENT_SCHEDULES

977: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
978:
979: Cursor site_ar_balance_in_ar_days IS
980: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
981: FROM AR_PAYMENT_SCHEDULES
982: WHERE CUSTOMER_SITE_USE_ID = p_header_rec.invoice_to_org_id
983: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
984: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y'
985: AND SYSDATE - TRX_DATE > l_open_ar_days;

Line 1670: from AR_PAYMENT_SCHEDULES

1666: -- Default to Y, in case there is one or more invoices due.
1667: p_check_past_due := 'Y';
1668: select 'Any Past due invoice'
1669: into l_dummy
1670: from AR_PAYMENT_SCHEDULES
1671: WHERE CUSTOMER_ID = p_customer_id
1672: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
1673: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y'
1674: AND AMOUNT_DUE_REMAINING > 0

Line 2398: FROM AR_PAYMENT_SCHEDULES

2394: WHERE CREDIT_CHECK_RULE_ID = p_credit_check_rule_id;
2395:
2396: Cursor ar_balance IS
2397: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
2398: FROM AR_PAYMENT_SCHEDULES
2399: WHERE CUSTOMER_ID = p_customer_id
2400: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
2401: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
2402:

Line 2405: FROM AR_PAYMENT_SCHEDULES

2401: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
2402:
2403: Cursor ar_balance_in_ar_days IS
2404: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
2405: FROM AR_PAYMENT_SCHEDULES
2406: WHERE CUSTOMER_ID = p_customer_id
2407: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
2408: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y'
2409: AND SYSDATE - TRX_DATE > l_open_ar_days;

Line 2660: FROM AR_PAYMENT_SCHEDULES

2656:
2657: -- CURSORS FOR SITE - LEVEL EXPOSURE CALCULATIONS
2658: Cursor site_ar_balance IS
2659: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
2660: FROM AR_PAYMENT_SCHEDULES
2661: WHERE CUSTOMER_SITE_USE_ID = p_invoice_to_org_id
2662: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
2663: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
2664:

Line 2667: FROM AR_PAYMENT_SCHEDULES

2663: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y';
2664:
2665: Cursor site_ar_balance_in_ar_days IS
2666: SELECT NVL(SUM(AMOUNT_DUE_REMAINING), 0)
2667: FROM AR_PAYMENT_SCHEDULES
2668: WHERE CUSTOMER_SITE_USE_ID = p_invoice_to_org_id
2669: AND INVOICE_CURRENCY_CODE = p_header_rec.transactional_curr_code
2670: AND NVL(RECEIPT_CONFIRMED_FLAG, 'Y') = 'Y'
2671: AND SYSDATE - TRX_DATE > l_open_ar_days;