APPS.OKL_LRF_GENERATE_PVT dependencies on OKL_LS_RT_FCTR_SETS_V

Line 181: FROM okl_ls_rt_fctr_sets_v a

177: ,b.std_rate_tmpl_ver_id
178: ,nvl(b.residual_tolerance, 0) residual_tolerance
179: ,b.rate_set_id
180: ,b.standard_rate
181: FROM okl_ls_rt_fctr_sets_v a
182: ,okl_fe_rate_set_versions b
183: WHERE a.id = b.rate_set_id
184: AND b.rate_set_version_id = csr_rate_set_version_id;
185: c_rate_set_rec c_rate_set%ROWTYPE;

Line 755: FROM okl_ls_rt_fctr_sets_v WHERE lrs_type_code = 'MANUAL');

751: SELECT rate_set_version_id
752: FROM okl_fe_rate_set_versions
753: WHERE effective_from_date BETWEEN p_start_date AND nvl(p_end_date, to_date('01-01-9999', 'dd-mm-yyyy'))
754: AND sts_code = 'NEW' AND rate_set_id NOT IN(SELECT id
755: FROM okl_ls_rt_fctr_sets_v WHERE lrs_type_code = 'MANUAL');
756:
757: BEGIN
758:
759: -- The parameter retcode returns 0 for success,