DBA Data[Home] [Help]

APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_QUICK_QUOTES_B

Line 273: FROM OKL_QUICK_QUOTES_B

269: ,TARGET_AMOUNT -- Need to solve for this amount only ...!
270: ,TARGET_FREQUENCY
271: ,TARGET_ARREARS
272: ,TARGET_PERIODS
273: FROM OKL_QUICK_QUOTES_B
274: WHERE ID = p_qq_id;
275: l_so_hdr_rec so_hdr_rec_type;
276: -- Local Variables
277: l_api_version CONSTANT NUMBER DEFAULT 1.0;

Line 472: FROM OKL_QUICK_QUOTES_B qq,

468: ,eot.end_of_term_name
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

Line 957: ,okl_quick_quotes_b qqh

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
961: WHERE qqh.end_of_term_option_id = eov.end_of_term_ver_id

Line 6024: FROM OKL_QUICK_QUOTES_B qq,

6020: ,eot.end_of_term_name
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

Line 7185: FROM OKL_QUICK_QUOTES_B qq,

7181: ,eot.end_of_term_name
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

Line 7196: FROM OKL_QUICK_QUOTES_B QQ

7192: --Bug 5884825 PAGARG start
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