APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_PRODUCTS

Line 155: okl_products_v pdt,

151: DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code)
152: esg_days_in_month_code
153: FROM
154: okl_k_headers khr,
155: okl_products_v pdt,
156: okl_ae_tmpt_sets_v aes,
157: OKL_ST_GEN_TMPT_SETS gts
158: WHERE
159: khr.pdt_id = pdt.id AND

Line 958: ,okl_products pdt

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
962: AND eov.end_of_term_id = eot.end_of_term_id

Line 1069: ,okl_products pdt

1065: gts.days_in_yr_code days_in_year,
1066: gts.id gts_id,
1067: pdt.id pdt_id
1068: FROM okl_lease_quotes_b lqh
1069: ,okl_products pdt
1070: ,okl_ae_tmpt_sets aes
1071: ,okl_st_gen_tmpt_sets gts
1072: WHERE lqh.product_id = pdt.id
1073: AND pdt.aes_id = aes.id

Line 7199: , OKL_PRODUCTS PDT

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
7203: AND QQ.ID = P_QQ_ID;

Line 7207: l_product_name okl_products.NAME%TYPE;--Bug 5884825 PAGARG

7203: AND QQ.ID = P_QQ_ID;
7204: --Bug 5884825 PAGARG End
7205:
7206: -- Local Variables
7207: l_product_name okl_products.NAME%TYPE;--Bug 5884825 PAGARG
7208: l_api_version CONSTANT NUMBER DEFAULT 1.0;
7209: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'price_quick_quote';
7210: l_return_status VARCHAR2(1);
7211: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

Line 8884: , OKL_PRODUCTS PDT

8880: CURSOR product_name_csr(qteid NUMBER)
8881: IS
8882: SELECT PDT.NAME PRODUCTNAME
8883: FROM OKL_LEASE_QUOTES_B QTE
8884: , OKL_PRODUCTS PDT
8885: WHERE QTE.PRODUCT_ID = PDT.ID
8886: AND QTE.ID = QTEID;
8887: --Bug 5884825 PAGARG end
8888:

Line 8890: l_product_name okl_products.NAME%TYPE;--Bug 5884825 PAGARG

8886: AND QTE.ID = QTEID;
8887: --Bug 5884825 PAGARG end
8888:
8889: -- Local Variables Declaration
8890: l_product_name okl_products.NAME%TYPE;--Bug 5884825 PAGARG
8891: l_lrs_details lrs_details_rec_type;
8892: l_lrs_factor lrs_factor_rec_type;
8893: l_lrs_levels lrs_levels_tbl_type;
8894: l_ac_rec_type OKL_EC_EVALUATE_PVT.okl_ac_rec_type;

Line 11714: , OKL_PRODUCTS PDT

11710: CURSOR product_name_csr(qteid NUMBER)
11711: IS
11712: SELECT PDT.NAME PRODUCTNAME
11713: FROM OKL_LEASE_QUOTES_B QTE
11714: , OKL_PRODUCTS PDT
11715: WHERE QTE.PRODUCT_ID = PDT.ID
11716: AND QTE.ID = qteid;
11717: --Bug 5884825 PAGARG end
11718:

Line 11719: l_product_name okl_products.NAME%TYPE;--Bug 5884825 PAGARG

11715: WHERE QTE.PRODUCT_ID = PDT.ID
11716: AND QTE.ID = qteid;
11717: --Bug 5884825 PAGARG end
11718:
11719: l_product_name okl_products.NAME%TYPE;--Bug 5884825 PAGARG
11720: l_day_count_method VARCHAR2(30);
11721: l_days_in_month VARCHAR2(30);
11722: l_days_in_year VARCHAR2(30);
11723: l_currency VARCHAR2(30);