APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKL_K_RATE_PARAMS

Line 221: l_principal_basis okl_k_rate_params.principal_basis_code%TYPE;

217: x_msg_data VARCHAR2(2000);
218: l_debug_enabled VARCHAR2(1);
219: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_INTEREST_DUE';
220:
221: l_principal_basis okl_k_rate_params.principal_basis_code%TYPE;
222: l_start_date DATE;
223: l_end_date DATE;
224: l_to_date DATE;
225: l_due_date DATE;

Line 235: FROM okl_k_rate_params

231: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
232:
233: CURSOR l_principal_basis_csr(cp_khr_id IN NUMBER) IS
234: SELECT principal_basis_code
235: FROM okl_k_rate_params
236: WHERE khr_id = cp_khr_id
237: AND parameter_type_code = 'ACTUAL'
238: AND TRUNC(SYSDATE) BETWEEN effective_from_date AND NVL(effective_to_date, TRUNC(SYSDATE));
239:

Line 471: l_principal_basis okl_k_rate_params.principal_basis_code%TYPE;

467: l_debug_enabled VARCHAR2(1);
468: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_PRINCIPAL_BAL';
469:
470: l_start_date DATE;
471: l_principal_basis okl_k_rate_params.principal_basis_code%TYPE;
472: l_principal_balance_tbl okl_variable_interest_pvt.principal_balance_tbl_typ;
473: l_principal_bal NUMBER;
474: l_stream_element_date DATE;
475:

Line 480: okl_k_rate_params rpm

476: CURSOR l_principal_basis_csr(cp_khr_id IN NUMBER) IS
477: SELECT chr.start_date, rpm.principal_basis_code
478: FROM okc_k_headers_b chr,
479: okl_k_headers khr,
480: okl_k_rate_params rpm
481: WHERE chr.id = khr.id
482: AND rpm.khr_id = khr.id
483: AND rpm.parameter_type_code = 'ACTUAL'
484: AND TRUNC(SYSDATE) BETWEEN rpm.effective_from_date AND NVL(rpm.effective_to_date, TRUNC(SYSDATE))

Line 1823: FROM okl_k_rate_params

1819: AND sel.stream_element_date <= cp_term_date;
1820:
1821: CURSOR l_catchup_csr (cp_khr_id IN NUMBER) IS
1822: SELECT catchup_start_date,DECODE(catchup_frequency_code,'MONTHLY',1,'QUARTERLY',3,'SEMI_ANNUAL',6,'ANNUAL',12) pay_freq
1823: FROM okl_k_rate_params
1824: WHERE khr_id = cp_khr_id
1825: AND parameter_type_code = 'ACTUAL';
1826:
1827: --Bug# 14049528