APPS.OKL_DEAL_CREATE_PUB dependencies on OKL_PRODUCTS_V

Line 5454: FROM OKL_PRODUCTS_V

5450: AND P.name = p_name;
5451:
5452: CURSOR l_product_csr IS
5453: SELECT id
5454: FROM OKL_PRODUCTS_V
5455: WHERE name = p_product_name;
5456:
5457: row_cnt NUMBER;
5458:

Line 5740: FROM OKL_PRODUCTS_V

5736: l_cust_acct_id okx_customer_accounts_v.id1%type := null;
5737:
5738: CURSOR l_product_csr IS
5739: SELECT id
5740: FROM OKL_PRODUCTS_V
5741: WHERE name = p_product_name;
5742:
5743: l_product_id OKL_PRODUCTS_V.id%type := null;
5744:

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

5739: SELECT id
5740: FROM OKL_PRODUCTS_V
5741: WHERE name = p_product_name;
5742:
5743: l_product_id OKL_PRODUCTS_V.id%type := null;
5744:
5745: row_cnt NUMBER;
5746:
5747: Cursor l_rbr_csr IS

Line 8148: FROM okl_products_v

8144: AND cust_site.site_use_code = 'LEGAL';
8145:
8146: CURSOR l_product_csr(product_id NUMBER) IS
8147: SELECT id,name,description
8148: FROM okl_products_v
8149: WHERE id = product_id;
8150:
8151: CURSOR l_currency_csr(p_currency_code VARCHAR2) IS
8152: SELECT currency_code, name