APPS.OKL_DEAL_CREAT_PVT dependencies on OKL_PRODUCTS_V

Line 5551: FROM OKL_PRODUCTS_V

5547: AND P.name = p_name;
5548:
5549: CURSOR l_product_csr IS
5550: SELECT id
5551: FROM OKL_PRODUCTS_V
5552: WHERE name = p_product_name;
5553:
5554: row_cnt NUMBER;
5555:

Line 5838: FROM OKL_PRODUCTS_V

5834: l_cust_acct_id okx_customer_accounts_v.id1%type := null;
5835:
5836: CURSOR l_product_csr IS
5837: SELECT id
5838: FROM OKL_PRODUCTS_V
5839: WHERE name = p_product_name;
5840:
5841: l_product_id OKL_PRODUCTS_V.id%type := null;
5842:

Line 5841: l_product_id OKL_PRODUCTS_V.id%type := null;

5837: SELECT id
5838: FROM OKL_PRODUCTS_V
5839: WHERE name = p_product_name;
5840:
5841: l_product_id OKL_PRODUCTS_V.id%type := null;
5842:
5843: row_cnt NUMBER;
5844:
5845: Cursor l_rbr_csr IS

Line 8343: FROM okl_products_v

8339: AND cust_site.site_use_code = 'LEGAL';
8340:
8341: CURSOR l_product_csr(product_id NUMBER) IS
8342: SELECT id,name,description
8343: FROM okl_products_v
8344: WHERE id = product_id;
8345:
8346: CURSOR l_currency_csr(p_currency_code VARCHAR2) IS
8347: SELECT currency_code, name