APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKL_K_RATE_PARAMS

Line 307: l_principal_basis okl_k_rate_params.principal_basis_code%TYPE;

303: x_msg_data VARCHAR2(2000);
304: l_debug_enabled VARCHAR2(1);
305: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_INTEREST_DUE';
306:
307: l_principal_basis okl_k_rate_params.principal_basis_code%TYPE;
308: l_start_date DATE;
309: l_end_date DATE;
310: l_to_date DATE;
311: l_due_date DATE;

Line 321: FROM okl_k_rate_params

317: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
318:
319: CURSOR l_principal_basis_csr(cp_khr_id IN NUMBER) IS
320: SELECT principal_basis_code
321: FROM okl_k_rate_params
322: WHERE khr_id = cp_khr_id
323: AND parameter_type_code = 'ACTUAL'
324: AND TRUNC(SYSDATE) BETWEEN effective_from_date AND NVL(effective_to_date, TRUNC(SYSDATE));
325:

Line 557: l_principal_basis okl_k_rate_params.principal_basis_code%TYPE;

553: l_debug_enabled VARCHAR2(1);
554: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_PRINCIPAL_BAL';
555:
556: l_start_date DATE;
557: l_principal_basis okl_k_rate_params.principal_basis_code%TYPE;
558: l_principal_balance_tbl okl_variable_interest_pvt.principal_balance_tbl_typ;
559: l_principal_bal NUMBER;
560: l_stream_element_date DATE;
561:

Line 566: okl_k_rate_params rpm

562: CURSOR l_principal_basis_csr(cp_khr_id IN NUMBER) IS
563: SELECT chr.start_date, rpm.principal_basis_code
564: FROM okc_k_headers_b chr,
565: okl_k_headers khr,
566: okl_k_rate_params rpm
567: WHERE chr.id = khr.id
568: AND rpm.khr_id = khr.id
569: AND rpm.parameter_type_code = 'ACTUAL'
570: AND TRUNC(SYSDATE) BETWEEN rpm.effective_from_date AND NVL(rpm.effective_to_date, TRUNC(SYSDATE))

Line 1870: FROM okl_k_rate_params

1866: AND sel.stream_element_date <= cp_term_date;
1867:
1868: CURSOR l_catchup_csr (cp_khr_id IN NUMBER) IS
1869: SELECT catchup_start_date,DECODE(catchup_frequency_code,'MONTHLY',1,'QUARTERLY',3,'SEMI_ANNUAL',6,'ANNUAL',12) pay_freq
1870: FROM okl_k_rate_params
1871: WHERE khr_id = cp_khr_id;
1872:
1873: BEGIN
1874: l_debug_enabled := okl_debug_pub.check_log_enabled;