APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_PRODUCTS

Line 123: ,okl_products ia_pdt

119: ,ia_pdt.NAME ia_product_name
120: FROM okl_pool_contents ia_pool_c
121: ,okc_k_headers_all_b ia_chr
122: ,okl_k_headers ia_khr
123: ,okl_products ia_pdt
124: ,okl_pools_all ia_pool
125: WHERE ia_pool_c.sty_code = p_sty_type
126: AND ia_pool_c.pol_id = ia_pool.id
127: AND ia_pool.khr_id = ia_chr.id

Line 402: FROM okl_products pdt

398: ,gts.deal_type deal_type
399: ,gts.tax_owner tax_owner
400: ,gts.interest_calc_meth_code interest_calc_meth_code
401: ,gts.revenue_recog_meth_code revenue_recog_meth_code
402: FROM okl_products pdt
403: ,okl_ae_tmpt_sets_all aes
404: ,okl_st_gen_tmpt_sets_all gts
405: WHERE pdt.aes_id = aes.id
406: AND aes.gts_id = gts.id

Line 629: FROM okl_products pdt

625: -- Cursor to fetch the product name
626: CURSOR c_get_pdt_name_csr( p_pdt_id NUMBER)
627: IS
628: SELECT pdt.name pdt_name
629: FROM okl_products pdt
630: WHERE pdt.id = p_pdt_id;
631:
632: -- Cursor to fetch the Line Style of the given Line ID
633: -- Used by FA Populate sources for validation Purposes

Line 770: FROM okl_products p

766:
767: -- get the reporting product based on the contract product .. MG uptake
768: CURSOR c_rep_pdt_csr(p_pdt_id number) IS
769: SELECT reporting_pdt_id
770: FROM okl_products p
771: WHERE p.id = p_pdt_id;
772:
773: -- get the book_type_name for asset book type code .. MG uptake
774: CURSOR get_book_type_name(p_book_type_code varchar2) IS