APPS.OKL_DEAL_CREAT_PVT dependencies on OKL_PRODUCTS

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 6833: CURSOR c_chk_pdt_effective(cp_pdt_id OKL_PRODUCTS.ID%TYPE, cp_effective_date okl_k_headers_full_v.start_date%type) IS

6829: l_count NUMBER;
6830: l_krpdel_tbl OKL_K_RATE_PARAMS_PVT.krpdel_tbl_type;
6831:
6832: -- ER# 9115610 - Start
6833: CURSOR c_chk_pdt_effective(cp_pdt_id OKL_PRODUCTS.ID%TYPE, cp_effective_date okl_k_headers_full_v.start_date%type) IS
6834: SELECT 'Y' FROM
6835: OKL_PRODUCTS
6836: WHERE ID = cp_pdt_id
6837: AND cp_effective_date BETWEEN FROM_DATE AND NVL(TO_DATE,cp_effective_date);

Line 6835: OKL_PRODUCTS

6831:
6832: -- ER# 9115610 - Start
6833: CURSOR c_chk_pdt_effective(cp_pdt_id OKL_PRODUCTS.ID%TYPE, cp_effective_date okl_k_headers_full_v.start_date%type) IS
6834: SELECT 'Y' FROM
6835: OKL_PRODUCTS
6836: WHERE ID = cp_pdt_id
6837: AND cp_effective_date BETWEEN FROM_DATE AND NVL(TO_DATE,cp_effective_date);
6838:
6839: l_chk_pdt VARCHAR(1) DEFAULT NULL;

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