APPS.OKL_DEAL_CREAT_PVT dependencies on OKL_PRODUCTS_V

Line 5576: FROM OKL_PRODUCTS_V

5572: AND P.name = p_name;
5573:
5574: CURSOR l_product_csr IS
5575: SELECT id
5576: FROM OKL_PRODUCTS_V
5577: WHERE name = p_product_name;
5578:
5579: row_cnt NUMBER;
5580:

Line 5864: FROM OKL_PRODUCTS_V

5860: l_cust_acct_id okx_customer_accounts_v.id1%type := null;
5861:
5862: CURSOR l_product_csr IS
5863: SELECT id
5864: FROM OKL_PRODUCTS_V
5865: WHERE name = p_product_name;
5866:
5867: l_product_id OKL_PRODUCTS_V.id%type := null;
5868:

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

5863: SELECT id
5864: FROM OKL_PRODUCTS_V
5865: WHERE name = p_product_name;
5866:
5867: l_product_id OKL_PRODUCTS_V.id%type := null;
5868:
5869: row_cnt NUMBER;
5870:
5871: Cursor l_rbr_csr IS

Line 8419: FROM okl_products_v

8415: and cust_site.b_status='A';
8416:
8417: CURSOR l_product_csr(product_id NUMBER) IS
8418: SELECT id,name,description
8419: FROM okl_products_v
8420: WHERE id = product_id;
8421:
8422: CURSOR l_currency_csr(p_currency_code VARCHAR2) IS
8423: SELECT currency_code, name