APPS.OKL_LRF_GENERATE_PVT dependencies on OKL_FE_EO_TERM_VERS

Line 208: ,okl_fe_eo_term_vers b

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:
212: CURSOR get_eot_values(eot_version_id IN number) IS

Line 221: ,okl_fe_eo_term_vers b

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:
225: CURSOR get_item_resd_vals(eot_version_id IN number

Line 230: ,okl_fe_eo_term_vers eotv

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
234: ,okl_fe_item_resdl_values irsval

Line 256: ,okl_fe_eo_term_vers eotv

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
260: ,okl_fe_item_resdl_values irsval

Line 281: ,okl_fe_eo_term_vers b

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
285: ,okl_fe_item_resdl_values f