APPS.OKL_LEASE_RATE_SETS_PVT dependencies on OKL_FE_EO_TERM_VERS

Line 25: FROM okl_fe_eo_term_vers

21:
22: CURSOR get_eot_version(p_eot_id number
23: ,p_eff_from IN date) IS
24: SELECT end_of_term_ver_id
25: FROM okl_fe_eo_term_vers
26: WHERE end_of_term_id = p_eot_id
27: AND p_eff_from BETWEEN effective_from_date AND nvl(effective_to_date, p_eff_from + 1)
28: AND sts_code = 'ACTIVE';
29: lp_lrvv_rec okl_lrvv_rec;

Line 247: FROM okl_fe_eo_term_vers

243:
244: CURSOR get_eot_version(p_eot_id number
245: ,p_eff_from IN date) IS
246: SELECT end_of_term_ver_id
247: FROM okl_fe_eo_term_vers
248: WHERE end_of_term_id = p_eot_id
249: AND p_eff_from BETWEEN effective_from_date AND nvl(effective_to_date, p_eff_from + 1)
250: AND sts_code = 'ACTIVE';
251: lp_lrvv_rec okl_lrvv_rec;

Line 907: FROM okl_fe_eo_term_vers

903:
904: CURSOR get_eot_version(p_eot_id number
905: ,p_eff_from IN date) IS
906: SELECT end_of_term_ver_id
907: FROM okl_fe_eo_term_vers
908: WHERE end_of_term_id = p_eot_id
909: AND p_eff_from BETWEEN effective_from_date AND nvl(effective_to_date, p_eff_from + 1)
910: AND sts_code = 'ACTIVE';
911: l_ver_no varchar2(30);

Line 2564: FROM okl_fe_eo_term_vers

2560:
2561: CURSOR get_eot_version IS
2562: SELECT end_of_term_ver_id
2563: ,version_number
2564: FROM okl_fe_eo_term_vers
2565: WHERE end_of_term_id = p_eot_id
2566: AND p_effective_from BETWEEN effective_from_date AND nvl(effective_to_date, p_effective_from + 1)
2567: AND sts_code = 'ACTIVE';
2568: l_eot_ver_id number;