APPS.OKL_LRF_GENERATE_PVT dependencies on OKL_FE_EO_TERMS_V

Line 207: FROM okl_fe_eo_terms_v a

203: AND lrs_eff_from BETWEEN c.datetime_valid AND nvl(c.datetime_invalid, lrs_eff_from + 1);
204:
205: CURSOR get_eot_resd_type(eot_version_id IN number) IS
206: SELECT a.eot_type_code
207: FROM okl_fe_eo_terms_v a
208: ,okl_fe_eo_term_vers b
209: WHERE a.end_of_term_id = b.end_of_term_id
210: AND b.end_of_term_ver_id = eot_version_id;
211:

Line 220: FROM okl_fe_eo_terms_v a

216: WHERE a.end_of_term_ver_id = eot_version_id;
217:
218: CURSOR get_eot_category_code(eot_version_id IN number) IS
219: SELECT category_type_code
220: FROM okl_fe_eo_terms_v a
221: ,okl_fe_eo_term_vers b
222: WHERE a.end_of_term_id = b.end_of_term_id
223: AND b.end_of_term_ver_id = eot_version_id;
224:

Line 229: FROM okl_fe_eo_terms_v eoth

225: CURSOR get_item_resd_vals(eot_version_id IN number
226: ,p_lrs_effective_from_date IN date) IS
227: SELECT DISTINCT irsval.term_in_months term_in_months
228: ,irsval.residual_value residual_value
229: FROM okl_fe_eo_terms_v eoth
230: ,okl_fe_eo_term_vers eotv
231: ,okl_fe_eo_term_objects eoto
232: ,OKL_FE_ITEM_RESIDUAL irsh
233: ,okl_itm_cat_rv_prcs irsv

Line 255: FROM okl_fe_eo_terms_v eoth

251: CURSOR get_itemcat_resd_vals(eot_version_id IN number
252: ,p_lrs_effective_from_date IN date) IS
253: SELECT DISTINCT irsval.term_in_months term_in_months
254: ,irsval.residual_value residual_value
255: FROM okl_fe_eo_terms_v eoth
256: ,okl_fe_eo_term_vers eotv
257: ,okl_fe_eo_term_objects eoto
258: ,OKL_FE_ITEM_RESIDUAL irsh
259: ,okl_itm_cat_rv_prcs irsv

Line 280: FROM okl_fe_eo_terms_v a

276: CURSOR get_resdcat_resd_vals(eot_version_id IN number
277: ,p_lrs_effective_from_date IN date) IS
278: SELECT DISTINCT f.term_in_months
279: ,f.residual_value
280: FROM okl_fe_eo_terms_v a
281: ,okl_fe_eo_term_vers b
282: ,okl_fe_eo_term_objects c
283: ,OKL_FE_ITEM_RESIDUAL d
284: ,okl_itm_cat_rv_prcs e