APPS.OKL_BPD_ADVANCED_CASH_APP_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 3313: l_ar_inv_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%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:
3313: l_ar_inv_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
3314: l_ar_inv_date RA_CUSTOMER_TRX_ALL.TRX_DATE%TYPE DEFAULT NULL;
3315:
3316: i NUMBER DEFAULT NULL;
3317: l_exit_loop NUMBER DEFAULT 0;

Line 3314: l_ar_inv_date RA_CUSTOMER_TRX_ALL.TRX_DATE%TYPE DEFAULT NULL;

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:
3313: l_ar_inv_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
3314: l_ar_inv_date RA_CUSTOMER_TRX_ALL.TRX_DATE%TYPE DEFAULT NULL;
3315:
3316: i NUMBER DEFAULT NULL;
3317: l_exit_loop NUMBER DEFAULT 0;
3318:

Line 3329: ar_invoice_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;

3325:
3326: -- abindal start bug#4897580 --
3327: l_inv_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
3328: l_rec_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
3329: ar_invoice_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
3330: ar_invoice_date OKL_BPD_LEASING_PAYMENT_TRX_V.INVOICE_DATE%TYPE DEFAULT NULL;
3331: -- abindal end bug#4897580 --
3332:
3333: -------------------------------------------------------------------------------

Line 3419: FROM RA_CUSTOMER_TRX_ALL

3415:
3416: -- get the ar invoice date
3417: CURSOR c_get_inv_date(cp_inv_id IN NUMBER) IS
3418: SELECT trx_date,org_id
3419: FROM RA_CUSTOMER_TRX_ALL
3420: WHERE customer_trx_id = cp_inv_id;
3421:
3422: -------------------------------------------------------------------------------
3423: CURSOR c_get_inv_lines(cp_inv_id IN NUMBER) IS