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 6865: , OKL_PRODUCTS PDT

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

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

6869: AND QQ.ID = P_QQ_ID;
6870: --Bug 5884825 PAGARG End
6871:
6872: -- Local Variables
6873: l_product_name okl_products.NAME%TYPE;--Bug 5884825 PAGARG
6874: l_api_version CONSTANT NUMBER DEFAULT 1.0;
6875: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'price_quick_quote';
6876: l_return_status VARCHAR2(1);
6877: l_module CONSTANT fnd_log_messages.module%TYPE := 'LEASE.ACCOUNTING.PRICING.'

Line 8546: , OKL_PRODUCTS PDT

8542: CURSOR product_name_csr(qteid NUMBER)
8543: IS
8544: SELECT PDT.NAME PRODUCTNAME
8545: FROM OKL_LEASE_QUOTES_B QTE
8546: , OKL_PRODUCTS PDT
8547: WHERE QTE.PRODUCT_ID = PDT.ID
8548: AND QTE.ID = QTEID;
8549: --Bug 5884825 PAGARG end
8550:

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

8548: AND QTE.ID = QTEID;
8549: --Bug 5884825 PAGARG end
8550:
8551: -- Local Variables Declaration
8552: l_product_name okl_products.NAME%TYPE;--Bug 5884825 PAGARG
8553: l_lrs_details lrs_details_rec_type;
8554: l_lrs_factor lrs_factor_rec_type;
8555: l_lrs_levels lrs_levels_tbl_type;
8556: l_ac_rec_type OKL_EC_EVALUATE_PVT.okl_ac_rec_type;

Line 10720: , OKL_PRODUCTS PDT

10716: CURSOR product_name_csr(qteid NUMBER)
10717: IS
10718: SELECT PDT.NAME PRODUCTNAME
10719: FROM OKL_LEASE_QUOTES_B QTE
10720: , OKL_PRODUCTS PDT
10721: WHERE QTE.PRODUCT_ID = PDT.ID
10722: AND QTE.ID = qteid;
10723: --Bug 5884825 PAGARG end
10724:

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

10721: WHERE QTE.PRODUCT_ID = PDT.ID
10722: AND QTE.ID = qteid;
10723: --Bug 5884825 PAGARG end
10724:
10725: l_product_name okl_products.NAME%TYPE;--Bug 5884825 PAGARG
10726: l_day_count_method VARCHAR2(30);
10727: l_days_in_month VARCHAR2(30);
10728: l_days_in_year VARCHAR2(30);
10729: l_currency VARCHAR2(30);