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 5691: FROM OKL_QUICK_QUOTES_B qq,

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

Line 6851: FROM OKL_QUICK_QUOTES_B qq,

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

Line 6862: FROM OKL_QUICK_QUOTES_B QQ

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