eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_PROD_QLTY_VAL_UV

Line 2957: --dkagrawa changed query to use okl_prod_qlty_val_uv than okl_product_parameter_v for performance

2953:
2954: ----------------------------------------------------------------
2955: -- Declare variable interest parameter cursor
2956: -----------------------------------------------------------------
2957: --dkagrawa changed query to use okl_prod_qlty_val_uv than okl_product_parameter_v for performance
2958: CURSOR c_int_param(cp_rate_param_rowid ROWID) IS
2959: SELECT krp.interest_index_id
2960: , NVL(krp.base_rate, 0) base_rate
2961: , NVL(krp.interest_start_date, chr.start_date) interest_start_date

Line 2991: , okl_prod_qlty_val_uv ppm

2987: , NULL pay_freq
2988: FROM okl_k_rate_params krp
2989: , okl_k_headers khr
2990: , okc_k_headers_b chr
2991: , okl_prod_qlty_val_uv ppm
2992: WHERE krp.rowid = cp_rate_param_rowid
2993: AND krp.khr_id = khr.id
2994: AND khr.id = chr.id
2995: --AND TRUNC(SYSDATE) BETWEEN krp.effective_from_date and NVL(krp.effective_to_date, trunc(SYSDATE))