APPS.OKL_SALES_QUOTE_QA_PVT dependencies on OKL_FE_RATE_SET_VERSIONS

Line 1816: from okl_ls_rt_fctr_sets_v lrs,okl_fe_rate_set_versions_v lrv

1812:
1813: --Cursor to fetch LRS Name
1814: CURSOR c_lrs_rec(p_srt_ver_id NUMBER) IS
1815: select lrs.name
1816: from okl_ls_rt_fctr_sets_v lrs,okl_fe_rate_set_versions_v lrv
1817: where lrs.id=lrv.rate_set_id
1818: and lrv.rate_set_version_id = p_srt_ver_id;
1819: --Cursor to Fetch SRT Name
1820: CURSOR c_srt_rec(p_srt_ver_id NUMBER) IS

Line 3334: FROM okl_fe_rate_set_versions

3330: AND tbl.template_yn='N';
3331:
3332: CURSOR is_rc_valid_csr(p_lrs_version_id IN NUMBER,p_exp_start_date IN DATE) IS
3333: SELECT 'Y'
3334: FROM okl_fe_rate_set_versions
3335: WHERE rate_set_version_id = p_lrs_version_id
3336: AND effective_from_date <= p_exp_start_date
3337: AND nvl(effective_to_date,p_exp_start_date) >= p_exp_start_date;
3338: