APPS.OKC_PRICE_PVT dependencies on OKX_LIST_HEADERS_V

Line 5498: from okx_list_headers_v a,okx_qp_list_lines_v b

5494: l_cle_price_tbl cle_price_tbl_type := px_cle_price_tbl;
5495: p_service_qty_tbl NUM_TBL_TYPE;
5496: CURSOR l_cur is
5497: Select name
5498: from okx_list_headers_v a,okx_qp_list_lines_v b
5499: where
5500: (b.id1 = to_number(substr(p_req_line_tbl(i).status_text,1,
5501: instr(p_req_line_tbl(i).status_text,',')-1))
5502: OR

Line 5615: from okx_list_headers_v

5611: If l_line_rec.pricelist_id is not null then
5612: Begin
5613: Select name
5614: into l_prc1
5615: from okx_list_headers_v
5616: where id1 = l_line_rec.pricelist_id;
5617: IF (l_debug = 'Y') THEN
5618: my_debug('15050 : select rowcount for pricelist name'||SQL%ROWCOUNT, 1);
5619: END IF;