APPS.OKL_INS_QUOTE_PVT dependencies on OKL_INS_PRODUCTS_B

Line 3493: FROM OKL_INS_PRODUCTS_B

3489: l_seq NUMBER ;
3490: l_policy_symbol VARCHAR2(10) ;
3491: CURSOR c_policy_symbol IS
3492: SELECT POLICY_SYMBOL
3493: FROM OKL_INS_PRODUCTS_B
3494: WHERE id = l_ipyv_rec.ipt_id;
3495: BEGIN
3496: l_ipyv_rec := l_inqv_rec ;
3497: BEGIN

Line 4591: FROM OKL_INS_PRODUCTS_B IPTB,

4587:
4588: -- inventory org change
4589: CURSOR okl_count_k_product_csr(p_isu_id NUMBER, p_total_oec NUMBER, p_from_date DATE ,p_inv_org_id NUMBER) IS
4590: SELECT COUNT(*) --Bug:3825159
4591: FROM OKL_INS_PRODUCTS_B IPTB,
4592: MTL_SYSTEM_ITEMS_B_KFV MSIB
4593: WHERE IPTB.IPD_ID =MSIB.INVENTORY_ITEM_ID
4594: AND iptb.isu_id = p_isu_id
4595: AND IPTB.IPT_TYPE = 'LEASE_PRODUCT'

Line 4606: OKL_INS_PRODUCTS_B IPTB,

4602: -- inventory org change
4603: CURSOR okl_k_product_csr(p_isu_id NUMBER, p_total_oec NUMBER, p_from_date DATE ,p_inv_org_id NUMBER) IS
4604: SELECT iptb.ID ,iptt.NAME --Bug:3825159
4605: FROM OKL_INS_PRODUCTS_TL IPTT,
4606: OKL_INS_PRODUCTS_B IPTB,
4607: MTL_SYSTEM_ITEMS_B_KFV MSIB
4608: WHERE IPTB.ID = IPTT.ID
4609: AND IPTT.LANGUAGE = USERENV('LANG')
4610: AND IPTB.IPD_ID = MSIB.INVENTORY_ITEM_ID

Line 7447: FROM OKL_INS_PRODUCTS_B

7443: l_policy_symbol VARCHAR2(10) ;
7444:
7445: CURSOR c_policy_symbol IS
7446: SELECT POLICY_SYMBOL
7447: FROM OKL_INS_PRODUCTS_B
7448: WHERE id = l_ipyv_rec.ipt_id;
7449:
7450: -- END Smoduga Fix for 3232868 Increment policy number for optional quotes.
7451: