DBA Data[Home] [Help]

APPS.OKL_CREATE_ADJST_PVT dependencies on AR_RECEIVABLES_TRX_ALL

Line 56: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;

52: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
53: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
54:
55: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
56: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
57:
58: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
59: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
60: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;

Line 106: FROM ar_receivables_trx_all

102: ------------------------------
103:
104: CURSOR c_get_receivables_trx_id (cp_set_of_books_id IN NUMBER) IS
105: SELECT RECEIVABLES_TRX_ID, NAME
106: FROM ar_receivables_trx_all
107: WHERE set_of_books_id = cp_set_of_books_id
108: AND name = 'OKL Adjustment';
109:
110:

Line 370: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;

366: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
367: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
368:
369: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
370: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
371:
372: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
373: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
374: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;

Line 434: FROM ar_receivables_trx_all

430: ------------------------------
431:
432: CURSOR c_get_receivables_trx_id (cp_set_of_books_id IN NUMBER) IS
433: SELECT RECEIVABLES_TRX_ID, NAME
434: FROM ar_receivables_trx_all
435: WHERE set_of_books_id = cp_set_of_books_id
436: AND name = 'OKL Adjustment';
437:
438: