DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKL_PROD_QLTY_VAL_UV

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

973: FUNCTION get_effective_int_rate(
974: x_return_status OUT NOCOPY VARCHAR2,
975: p_khr_id IN NUMBER,
976: p_effective_date IN DATE) RETURN NUMBER IS
977: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
978: CURSOR l_calc_basis_csr(cp_khr_id IN NUMBER) IS
979: SELECT ppm.quality_val interest_calculation_basis
980: , end_date
981: FROM okl_k_headers_full_v khr,

Line 982: okl_prod_qlty_val_uv ppm

978: CURSOR l_calc_basis_csr(cp_khr_id IN NUMBER) IS
979: SELECT ppm.quality_val interest_calculation_basis
980: , end_date
981: FROM okl_k_headers_full_v khr,
982: okl_prod_qlty_val_uv ppm
983: WHERE khr.pdt_id = ppm.pdt_id
984: AND ppm.quality_name = 'INTEREST_CALCULATION_BASIS'
985: AND khr.id = cp_khr_id;
986: