DBA Data[Home] [Help]

APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_FE_STD_RT_TMP_ALL_B

Line 4916: FROM okl_fe_std_rt_tmp_all_b hdr,

4912: p_srt_header_id IN NUMBER,
4913: p_date IN DATE)
4914: IS
4915: SELECT indx.value srt_rate
4916: FROM okl_fe_std_rt_tmp_all_b hdr,
4917: okl_index_values indx
4918: WHERE hdr.std_rate_tmpl_id = p_srt_header_id
4919: AND hdr.index_id = indx.idx_id
4920: AND p_date BETWEEN indx.datetime_valid AND NVL(indx.datetime_invalid,p_date+1);