APPS.OKL_K_RATE_PARAMS_PVT dependencies on OKL_PRODUCTS_V

Line 295: okl_products_v pdt

291: pdt.id pid,
292: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
293: FROM okc_k_headers_b CHR,
294: okl_k_headers khr,
295: okl_products_v pdt
296: WHERE khr.id = CHR.id
297: AND CHR.id = chrId
298: AND khr.pdt_id = pdt.id;
299:

Line 374: okl_products_v pdt

370: pdt.id pid,
371: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
372: FROM okc_k_headers_b CHR,
373: okl_k_headers khr,
374: okl_products_v pdt
375: WHERE khr.id = CHR.id
376: AND CHR.id = chrId
377: AND khr.pdt_id = pdt.id;
378:

Line 2770: okl_products_v pdt

2766: pdt.id pid,
2767: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
2768: FROM okc_k_headers_b CHR,
2769: okl_k_headers khr,
2770: okl_products_v pdt
2771: WHERE khr.id = CHR.id
2772: AND CHR.id = chrId
2773: AND khr.pdt_id = pdt.id(+);
2774:

Line 3065: p_product_id IN okl_products_v.id%type,

3061: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3062: x_return_status OUT NOCOPY VARCHAR2,
3063: x_msg_count OUT NOCOPY NUMBER,
3064: x_msg_data OUT NOCOPY VARCHAR2,
3065: p_product_id IN okl_products_v.id%type,
3066: p_k_rate_tbl IN krpv_tbl_type,
3067: --Bug# 7440232
3068: p_validate_flag IN VARCHAR2 DEFAULT 'Y') IS
3069:

Line 3082: from okl_products_v

3078: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In validate_k_rate_params from UI/contract import...');
3079: END IF;
3080: /*begin
3081: select id into l_pdt_id
3082: from okl_products_v
3083: where name = p_product_name;
3084: exception when no_data_found then
3085: null;
3086: -- ToDo AKP: Set Message : Product not found. Raise error.