DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKL_PROD_QLTY_VAL_UV

Line 1024: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

1020: FUNCTION get_effective_int_rate(
1021: x_return_status OUT NOCOPY VARCHAR2,
1022: p_khr_id IN NUMBER,
1023: p_effective_date IN DATE) RETURN NUMBER IS
1024: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
1025: CURSOR l_calc_basis_csr(cp_khr_id IN NUMBER) IS
1026: SELECT ppm.quality_val interest_calculation_basis
1027: , end_date
1028: FROM okl_k_headers_full_v khr,

Line 1029: okl_prod_qlty_val_uv ppm

1025: CURSOR l_calc_basis_csr(cp_khr_id IN NUMBER) IS
1026: SELECT ppm.quality_val interest_calculation_basis
1027: , end_date
1028: FROM okl_k_headers_full_v khr,
1029: okl_prod_qlty_val_uv ppm
1030: WHERE khr.pdt_id = ppm.pdt_id
1031: AND ppm.quality_name = 'INTEREST_CALCULATION_BASIS'
1032: AND khr.id = cp_khr_id;
1033: