APPS.OKL_SALES_QUOTE_QA_PVT dependencies on OKL_FE_STD_RT_TMP_V

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 321: okl_fe_std_rt_tmp_v srt

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;
325:

Line 1781: l_obj_name okl_fe_std_rt_tmp_v.template_name%TYPE;

1777: l_item_cat_id NUMBER;
1778: lp_vp_id NUMBER;
1779: l_check_ec_flag boolean:=FALSE;
1780: x_eligible boolean;
1781: l_obj_name okl_fe_std_rt_tmp_v.template_name%TYPE;
1782: l_message_name VARCHAR2(30);
1783: cursor c_qq_header_rec(p_quote_id NUMBER) IS
1784: SELECT t1.* FROM OKL_QUICK_QUOTES_B t1
1785: WHERE t1.id = p_quote_id;

Line 1823: okl_fe_std_rt_tmp_v srt,

1819: --Cursor to Fetch SRT Name
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

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: