APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_FE_EO_TERMS_ALL_B

Line 474: okl_fe_eo_terms_all_b eot

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;
478: -- Local Variables

Line 955: FROM okl_fe_eo_terms_all_b eot

951: SELECT gts.days_in_month_code days_in_month,
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

Line 5693: okl_fe_eo_terms_all_b eot

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;
5697: -- Local Variables

Line 6853: okl_fe_eo_terms_all_b eot

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;
6857:

Line 6864: , OKL_FE_EO_TERMS_ALL_B EOT

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
6868: AND PDT.ID = EOT.PRODUCT_ID

Line 8759: okl_fe_eo_terms_all_b eot

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;
8763: l_eot_type_code VARCHAR2(30);

Line 10699: okl_fe_eo_terms_all_b eot

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;
10703: l_eot_type_code VARCHAR2(30);