DBA Data[Home] [Help]

APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_FE_STD_RT_TMP_V

Line 4925: FROM okl_fe_std_rt_tmp_v hdr,

4921: hdr.frequency_code frequency_code,
4922: ver.adj_mat_version_id adj_mat_version_id,
4923: ver.min_adj_rate min_adj_rate,
4924: ver.max_adj_rate max_adj_rate
4925: FROM okl_fe_std_rt_tmp_v hdr,
4926: okl_fe_std_rt_tmp_vers ver
4927: WHERE ver.std_rate_tmpl_ver_id = p_srt_version_id AND
4928: hdr.std_rate_tmpl_id = ver.std_rate_tmpl_id AND
4929: ver.effective_from_date <= p_date AND

Line 4926: okl_fe_std_rt_tmp_vers ver

4922: ver.adj_mat_version_id adj_mat_version_id,
4923: ver.min_adj_rate min_adj_rate,
4924: ver.max_adj_rate max_adj_rate
4925: FROM okl_fe_std_rt_tmp_v hdr,
4926: okl_fe_std_rt_tmp_vers ver
4927: WHERE ver.std_rate_tmpl_ver_id = p_srt_version_id AND
4928: hdr.std_rate_tmpl_id = ver.std_rate_tmpl_id AND
4929: ver.effective_from_date <= p_date AND
4930: nvl(ver.effective_to_date, p_date) >= p_date;