DBA Data[Home] [Help]

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 5692: okl_fe_eo_term_vers eotversion,

5688: ,eot.eot_type_code eot_type_code
5689: ,eot.end_of_term_id end_of_term_id
5690: ,eotversion.end_of_term_ver_id
5691: FROM OKL_QUICK_QUOTES_B qq,
5692: okl_fe_eo_term_vers eotversion,
5693: okl_fe_eo_terms_all_b eot
5694: WHERE qq.END_OF_TERM_OPTION_ID = eotversion.end_of_term_ver_id
5695: AND eot.end_of_term_id = eotversion.end_of_term_id
5696: AND qq.id = p_qq_id;

Line 6852: okl_fe_eo_term_vers eotversion,

6848: ,eot.eot_type_code eot_type_code
6849: ,eot.end_of_term_id end_of_term_id
6850: ,eotversion.end_of_term_ver_id
6851: FROM OKL_QUICK_QUOTES_B qq,
6852: okl_fe_eo_term_vers eotversion,
6853: okl_fe_eo_terms_all_b eot
6854: WHERE qq.END_OF_TERM_OPTION_ID = eotversion.end_of_term_ver_id
6855: AND eot.end_of_term_id = eotversion.end_of_term_id
6856: AND qq.id = p_qq_id;

Line 6863: , OKL_FE_EO_TERM_VERS EOTVERSION

6859: CURSOR get_product_name( p_qq_id NUMBER )
6860: IS
6861: SELECT PDT.NAME PRODUCTNAME
6862: FROM OKL_QUICK_QUOTES_B QQ
6863: , OKL_FE_EO_TERM_VERS EOTVERSION
6864: , OKL_FE_EO_TERMS_ALL_B EOT
6865: , OKL_PRODUCTS PDT
6866: WHERE QQ.END_OF_TERM_OPTION_ID = EOTVERSION.END_OF_TERM_VER_ID
6867: AND EOT.END_OF_TERM_ID = EOTVERSION.END_OF_TERM_ID

Line 8758: okl_fe_eo_term_vers eotversion,

8754: ,eot.eot_type_code eot_type_code
8755: ,eot.end_of_term_id end_of_term_id
8756: ,eotversion.end_of_term_ver_id
8757: FROM OKL_LEASE_QUOTES_B lq,
8758: okl_fe_eo_term_vers eotversion,
8759: okl_fe_eo_terms_all_b eot
8760: WHERE lq.END_OF_TERM_OPTION_ID = eotversion.end_of_term_ver_id
8761: AND eot.end_of_term_id = eotversion.end_of_term_id
8762: AND lq.id = p_lq_id;

Line 10698: okl_fe_eo_term_vers eotversion,

10694: ,eot.eot_type_code eot_type_code
10695: ,eot.end_of_term_id end_of_term_id
10696: ,eotversion.end_of_term_ver_id
10697: FROM OKL_LEASE_QUOTES_B lq,
10698: okl_fe_eo_term_vers eotversion,
10699: okl_fe_eo_terms_all_b eot
10700: WHERE lq.END_OF_TERM_OPTION_ID = eotversion.end_of_term_ver_id
10701: AND eot.end_of_term_id = eotversion.end_of_term_id
10702: AND lq.id = p_lq_id;