APPS.OKL_CREATE_ADJST_PVT dependencies on AR_RECEIVABLES_TRX_ALL

Line 306: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;

302: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
303: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
304:
305: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
306: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
307:
308: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
309: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
310: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;

Line 343: FROM ar_receivables_trx_all

339: ------------------------------
340:
341: CURSOR c_get_receivables_trx_id (cp_set_of_books_id IN NUMBER) IS
342: SELECT RECEIVABLES_TRX_ID, NAME
343: FROM ar_receivables_trx_all
344: WHERE set_of_books_id = cp_set_of_books_id
345: AND name = 'OKL Adjustment';
346:
347:

Line 693: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;

689: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
690: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
691:
692: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
693: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
694:
695: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
696: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
697: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;

Line 736: FROM ar_receivables_trx_all

732: ------------------------------
733:
734: CURSOR c_get_receivables_trx_id (cp_set_of_books_id IN NUMBER) IS
735: SELECT RECEIVABLES_TRX_ID, NAME
736: FROM ar_receivables_trx_all
737: WHERE set_of_books_id = cp_set_of_books_id
738: AND name = 'OKL Adjustment';
739:
740: