APPS.OKL_LEASE_RATE_SETS_PVT dependencies on STANDARD

Line 591: --get max of start dates of standard quotes referencing the lrs header of this version

587: END IF;
588: RETURN l_prev_ver_eff_to + 1;
589: END IF;
590:
591: --get max of start dates of standard quotes referencing the lrs header of this version
592:
593: OPEN lrs_lq_csr;
594: FETCH lrs_lq_csr INTO l_std_qte_eff_from ;
595: CLOSE lrs_lq_csr;

Line 1375: SELECT nvl(lrs_rate,standard_rate) interest_rate

1371: FROM okl_fe_rate_set_versions
1372: WHERE rate_set_id = p_lrt_id AND version_number = p_version_number;
1373:
1374: CURSOR get_interest_rate(p_lrv_id IN number) IS
1375: SELECT nvl(lrs_rate,standard_rate) interest_rate
1376: FROM okl_fe_rate_set_versions lrsv
1377: WHERE lrsv.rate_set_version_id = p_lrv_id;
1378: l_ech_rec okl_ech_rec;
1379: l_ecl_tbl okl_ecl_tbl;