DBA Data[Home] [Help]

APPS.OKL_CASH_RECEIPT dependencies on OKL_BPD_LEASING_PAYMENT_TRX_V

Line 58: ar_invoice_date OKL_BPD_LEASING_PAYMENT_TRX_V.INVOICE_DATE%TYPE DEFAULT NULL;

54: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
55: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
56:
57: ar_invoice_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
58: ar_invoice_date OKL_BPD_LEASING_PAYMENT_TRX_V.INVOICE_DATE%TYPE DEFAULT NULL;
59:
60: l_inv_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
61: l_rec_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
62: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

Line 281: FROM OKL_BPD_LEASING_PAYMENT_TRX_V

277: GROUP BY invoice_number;
278:
279: /* added to address bug 4208639 */
280: SELECT invoice_date INTO ar_invoice_date
281: FROM OKL_BPD_LEASING_PAYMENT_TRX_V
282: WHERE receivables_invoice_number = ar_invoice_num;
283:
284: IF l_currency_code = l_xcrv_rec.currency_code THEN
285: l_applied_amount := l_xcav_tbl(i).amount_applied;