DBA Data[Home] [Help]

APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_FE_STD_RT_TMP_V

Line 4903: FROM okl_fe_std_rt_tmp_v hdr,

4899: hdr.frequency_code frequency_code,
4900: ver.adj_mat_version_id adj_mat_version_id,
4901: ver.min_adj_rate min_adj_rate,
4902: ver.max_adj_rate max_adj_rate
4903: FROM okl_fe_std_rt_tmp_v hdr,
4904: okl_fe_std_rt_tmp_vers ver
4905: WHERE ver.std_rate_tmpl_ver_id = p_srt_version_id AND
4906: hdr.std_rate_tmpl_id = ver.std_rate_tmpl_id AND
4907: ver.effective_from_date <= p_date AND

Line 4904: okl_fe_std_rt_tmp_vers ver

4900: ver.adj_mat_version_id adj_mat_version_id,
4901: ver.min_adj_rate min_adj_rate,
4902: ver.max_adj_rate max_adj_rate
4903: FROM okl_fe_std_rt_tmp_v hdr,
4904: okl_fe_std_rt_tmp_vers ver
4905: WHERE ver.std_rate_tmpl_ver_id = p_srt_version_id AND
4906: hdr.std_rate_tmpl_id = ver.std_rate_tmpl_id AND
4907: ver.effective_from_date <= p_date AND
4908: nvl(ver.effective_to_date, p_date) >= p_date;