APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_K_RATE_PARAMS

Line 1459: l_principal_basis OKL_K_RATE_PARAMS.PRINCIPAL_BASIS_CODE%TYPE;

1455: l_factor NUMBER := 0;
1456: l_pymnt_end_date DATE := NULL;
1457: l_rent_amt_zero BOOLEAN := FALSE;
1458: l_rent_strm_name OKL_STRM_TYPE_V.NAME%TYPE;
1459: l_principal_basis OKL_K_RATE_PARAMS.PRINCIPAL_BASIS_CODE%TYPE;
1460: l_contract_end_date DATE;
1461: l_var_int_strm_name OKL_STRM_TYPE_V.NAME%TYPE;
1462:
1463: CURSOR get_principal_basis(p_khr_id NUMBER) IS

Line 1465: FROM OKL_K_RATE_PARAMS

1461: l_var_int_strm_name OKL_STRM_TYPE_V.NAME%TYPE;
1462:
1463: CURSOR get_principal_basis(p_khr_id NUMBER) IS
1464: SELECT PRINCIPAL_BASIS_CODE
1465: FROM OKL_K_RATE_PARAMS
1466: WHERE KHR_ID = p_khr_id;
1467: --end bkatraga
1468:
1469: CURSOR l_pmnt_lns_in_hdr(p_id OKC_RULES_B.ID%TYPE, chrId NUMBER) IS

Line 1650: Okl_K_Rate_Params_Pvt.get_product(

1646: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1647: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type...');
1648: END IF;
1649:
1650: Okl_K_Rate_Params_Pvt.get_product(
1651: p_api_version => 1,
1652: p_init_msg_list => Okc_Api.G_FALSE,
1653: x_return_status => x_return_status,
1654: x_msg_count => x_msg_count,

Line 1945: Okl_K_Rate_Params_Pvt.check_base_rate(

1941: END IF;
1942: -- If Principal payment is defined, check if base_rate defined
1943: IF (l_principal_payment_found) THEN
1944: --print('Yes, Principal payment found: Checking base rate...');
1945: Okl_K_Rate_Params_Pvt.check_base_rate(
1946: p_khr_id => p_chr_id,
1947: x_base_rate_defined => l_base_rate_defined,
1948: x_return_status => l_return_status);
1949:

Line 2542: Okl_K_Rate_Params_Pvt.validate_k_rate_params(

2538:
2539: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before calling validate_k_rate_params...');
2541: END IF;
2542: Okl_K_Rate_Params_Pvt.validate_k_rate_params(
2543: p_api_version => 1,
2544: p_init_msg_list => Okl_Api.G_FALSE,
2545: x_return_status => x_return_status,
2546: x_msg_count => x_msg_count,

Line 14323: FROM okl_k_rate_params

14319: l_chr_rec chr_csr%ROWTYPE;
14320:
14321: CURSOR vir_params_csr(p_chr_id IN NUMBER) IS
14322: SELECT interest_start_date
14323: FROM okl_k_rate_params
14324: WHERE khr_id = p_chr_id
14325: AND parameter_type_code = 'ACTUAL'
14326: AND effective_to_date IS NULL;
14327: