DBA Data[Home] [Help]

APPS.OKL_LRF_GENERATE_PVT dependencies on STANDARD

Line 180: ,b.standard_rate

176: ,b.end_of_term_ver_id
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;

Line 381: l_rate := c_rate_set_rec.standard_rate;

377: FETCH get_srt_index_rate INTO l_rate ;
378: CLOSE get_srt_index_rate;
379: END IF;*/
380: IF c_rate_set_rec.std_rate_tmpl_ver_id IS NOT NULL THEN
381: l_rate := c_rate_set_rec.standard_rate;
382: END IF;
383: END IF;
384: --if rate is still null then throw error
385: IF l_rate IS NULL THEN --set message Rate cannot be determined for RATE_SET_VERSION_ID