DBA Data[Home] [Help]

APPS.OKL_SALES_QUOTE_QA_PVT dependencies on OKL_FE_STD_RT_TMP_VERS

Line 320: okl_fe_std_rt_tmp_vers srv,

316: srv.adj_mat_version_id adj_mat_version_id,
317: srv.min_adj_rate,
318: srv.max_adj_rate
319: from
320: okl_fe_std_rt_tmp_vers srv,
321: okl_fe_std_rt_tmp_v srt
322: where
323: srv.std_rate_tmpl_ver_id= p_srt_version_id
324: AND srt.std_rate_tmpl_id=srv.std_rate_tmpl_id;

Line 1824: okl_fe_std_rt_tmp_vers srv

1820: CURSOR c_srt_rec(p_srt_ver_id NUMBER) IS
1821: select srt.template_name as name
1822: from
1823: okl_fe_std_rt_tmp_v srt,
1824: okl_fe_std_rt_tmp_vers srv
1825: where srt.std_rate_tmpl_id=srv.std_rate_tmpl_id
1826: AND srv.std_rate_tmpl_ver_id = p_srt_ver_id;
1827: --Bug # 5050143 ssdeshpa end
1828: BEGIN

Line 3341: FROM okl_fe_std_rt_tmp_vers

3337: AND nvl(effective_to_date,p_exp_start_date) >= p_exp_start_date;
3338:
3339: CURSOR is_srt_valid_csr(p_srt_version_id IN NUMBER,p_exp_start_date IN DATE) IS
3340: SELECT 'Y'
3341: FROM okl_fe_std_rt_tmp_vers
3342: WHERE std_rate_tmpl_ver_id = p_srt_version_id
3343: AND effective_from_date <= p_exp_start_date
3344: AND nvl(effective_to_date,p_exp_start_date) >= p_exp_start_date;
3345: