eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_BPD_ADVANCED_CASH_APP_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 967: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;

963: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
964: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
965:
966:
967: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
968:
969: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
970: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
971: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;

Line 1255: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;

1251: l_cross_currency_allowed VARCHAR2(1) DEFAULT p_cross_currency_allowed;
1252:
1253: l_converted_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
1254:
1255: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
1256:
1257: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
1258: l_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
1259: l_expired_flag OKL_TRX_CSH_RECEIPT_V.FULLY_APPLIED_FLAG%TYPE;

Line 3296: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;

3292: l_receipt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT p_receipt_date;
3293: l_receipt_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_receipt_currency;
3294: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT p_receipt_amount;
3295:
3296: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
3297: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
3298:
3299: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code; -- entered currency code
3300:

Line 3308: l_invoice_balance AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%TYPE DEFAULT NULL;

3304: l_prev_applied_amt AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
3305:
3306: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
3307:
3308: l_invoice_balance AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%TYPE DEFAULT NULL;
3309:
3310: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
3311: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
3312:

Line 3399: FROM AR_PAYMENT_SCHEDULES_ALL

3395: -- Changed c_ver_inv_amt(cp_receivables_invoice_id IN NUMBER) SQL definition
3396: -- verify receivables invoice amount
3397: CURSOR c_ver_inv_amt(cp_receivables_invoice_id IN NUMBER) IS
3398: SELECT amount_due_remaining
3399: FROM AR_PAYMENT_SCHEDULES_ALL
3400: WHERE customer_trx_id = cp_receivables_invoice_id;
3401:
3402: -------------------------------------------------------------------------------
3403: