APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_FE_EO_TERM_VERS

Line 473: okl_fe_eo_term_vers eotversion,

469: ,eot.eot_type_code eot_type_code
470: ,eot.end_of_term_id end_of_term_id
471: ,eotversion.end_of_term_ver_id
472: FROM OKL_QUICK_QUOTES_B qq,
473: okl_fe_eo_term_vers eotversion,
474: okl_fe_eo_terms_all_b eot
475: WHERE qq.END_OF_TERM_OPTION_ID = eotversion.end_of_term_ver_id
476: AND eot.end_of_term_id = eotversion.end_of_term_id
477: AND qq.id = p_qq_id;

Line 956: ,okl_fe_eo_term_vers eov

952: gts.days_in_yr_code days_in_year,
953: gts.id gts_id,
954: pdt.id pdt_id
955: FROM okl_fe_eo_terms_all_b eot
956: ,okl_fe_eo_term_vers eov
957: ,okl_quick_quotes_b qqh
958: ,okl_products pdt
959: ,okl_ae_tmpt_sets aes
960: ,okl_st_gen_tmpt_sets gts

Line 6025: okl_fe_eo_term_vers eotversion,

6021: ,eot.eot_type_code eot_type_code
6022: ,eot.end_of_term_id end_of_term_id
6023: ,eotversion.end_of_term_ver_id
6024: FROM OKL_QUICK_QUOTES_B qq,
6025: okl_fe_eo_term_vers eotversion,
6026: okl_fe_eo_terms_all_b eot
6027: WHERE qq.END_OF_TERM_OPTION_ID = eotversion.end_of_term_ver_id
6028: AND eot.end_of_term_id = eotversion.end_of_term_id
6029: AND qq.id = p_qq_id;

Line 7186: okl_fe_eo_term_vers eotversion,

7182: ,eot.eot_type_code eot_type_code
7183: ,eot.end_of_term_id end_of_term_id
7184: ,eotversion.end_of_term_ver_id
7185: FROM OKL_QUICK_QUOTES_B qq,
7186: okl_fe_eo_term_vers eotversion,
7187: okl_fe_eo_terms_all_b eot
7188: WHERE qq.END_OF_TERM_OPTION_ID = eotversion.end_of_term_ver_id
7189: AND eot.end_of_term_id = eotversion.end_of_term_id
7190: AND qq.id = p_qq_id;

Line 7197: , OKL_FE_EO_TERM_VERS EOTVERSION

7193: CURSOR get_product_name( p_qq_id NUMBER )
7194: IS
7195: SELECT PDT.NAME PRODUCTNAME
7196: FROM OKL_QUICK_QUOTES_B QQ
7197: , OKL_FE_EO_TERM_VERS EOTVERSION
7198: , OKL_FE_EO_TERMS_ALL_B EOT
7199: , OKL_PRODUCTS PDT
7200: WHERE QQ.END_OF_TERM_OPTION_ID = EOTVERSION.END_OF_TERM_VER_ID
7201: AND EOT.END_OF_TERM_ID = EOTVERSION.END_OF_TERM_ID

Line 9098: okl_fe_eo_term_vers eotversion,

9094: ,eot.eot_type_code eot_type_code
9095: ,eot.end_of_term_id end_of_term_id
9096: ,eotversion.end_of_term_ver_id
9097: FROM OKL_LEASE_QUOTES_B lq,
9098: okl_fe_eo_term_vers eotversion,
9099: okl_fe_eo_terms_all_b eot
9100: WHERE lq.END_OF_TERM_OPTION_ID = eotversion.end_of_term_ver_id
9101: AND eot.end_of_term_id = eotversion.end_of_term_id
9102: AND lq.id = p_lq_id;

Line 11692: okl_fe_eo_term_vers eotversion,

11688: ,eot.eot_type_code eot_type_code
11689: ,eot.end_of_term_id end_of_term_id
11690: ,eotversion.end_of_term_ver_id
11691: FROM OKL_LEASE_QUOTES_B lq,
11692: okl_fe_eo_term_vers eotversion,
11693: okl_fe_eo_terms_all_b eot
11694: WHERE lq.END_OF_TERM_OPTION_ID = eotversion.end_of_term_ver_id
11695: AND eot.end_of_term_id = eotversion.end_of_term_id
11696: AND lq.id = p_lq_id;