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 6026: okl_fe_eo_terms_all_b eot

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

Line 7187: okl_fe_eo_terms_all_b eot

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

Line 7198: , OKL_FE_EO_TERMS_ALL_B EOT

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

Line 9099: okl_fe_eo_terms_all_b eot

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

Line 11693: okl_fe_eo_terms_all_b eot

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