DBA Data[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_K_RATE_PARAMS

Line 6318: FROM okl_k_rate_params krp

6314: --Bug# 14553382
6315: CURSOR c_int_param(p_khr_id NUMBER,
6316: p_accrual_date DATE) IS
6317: SELECT krp.interest_start_date
6318: FROM okl_k_rate_params krp
6319: WHERE krp.khr_id = p_khr_id
6320: AND krp.parameter_type_code = 'ACTUAL'
6321: AND p_accrual_date BETWEEN krp.effective_from_date AND NVL(krp.effective_to_date, trunc(p_accrual_date));
6322:

Line 6323: l_interest_start_date okl_k_rate_params.interest_start_date%TYPE;

6319: WHERE krp.khr_id = p_khr_id
6320: AND krp.parameter_type_code = 'ACTUAL'
6321: AND p_accrual_date BETWEEN krp.effective_from_date AND NVL(krp.effective_to_date, trunc(p_accrual_date));
6322:
6323: l_interest_start_date okl_k_rate_params.interest_start_date%TYPE;
6324: --Bug# 14553382
6325:
6326: BEGIN
6327: WRITE_TO_LOG('');