APPS.OKL_K_RATE_PARAMS_PVT dependencies on OKL_PRODUCTS_V

Line 285: okl_products_v pdt

281: pdt.id pid,
282: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
283: FROM okc_k_headers_b CHR,
284: okl_k_headers khr,
285: okl_products_v pdt
286: WHERE khr.id = CHR.id
287: AND CHR.id = chrId
288: AND khr.pdt_id = pdt.id;
289:

Line 364: okl_products_v pdt

360: pdt.id pid,
361: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
362: FROM okc_k_headers_b CHR,
363: okl_k_headers khr,
364: okl_products_v pdt
365: WHERE khr.id = CHR.id
366: AND CHR.id = chrId
367: AND khr.pdt_id = pdt.id;
368:

Line 2760: okl_products_v pdt

2756: pdt.id pid,
2757: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
2758: FROM okc_k_headers_b CHR,
2759: okl_k_headers khr,
2760: okl_products_v pdt
2761: WHERE khr.id = CHR.id
2762: AND CHR.id = chrId
2763: AND khr.pdt_id = pdt.id(+);
2764:

Line 3055: p_product_id IN okl_products_v.id%type,

3051: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3052: x_return_status OUT NOCOPY VARCHAR2,
3053: x_msg_count OUT NOCOPY NUMBER,
3054: x_msg_data OUT NOCOPY VARCHAR2,
3055: p_product_id IN okl_products_v.id%type,
3056: p_k_rate_tbl IN krpv_tbl_type,
3057: --Bug# 7440232
3058: p_validate_flag IN VARCHAR2 DEFAULT 'Y') IS
3059:

Line 3072: from okl_products_v

3068: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In validate_k_rate_params from UI/contract import...');
3069: END IF;
3070: /*begin
3071: select id into l_pdt_id
3072: from okl_products_v
3073: where name = p_product_name;
3074: exception when no_data_found then
3075: null;
3076: -- ToDo AKP: Set Message : Product not found. Raise error.