APPS.OKC_CLE_PVT dependencies on QP_LIST_LINES

Line 2235: from OKX_QP_LIST_LINES_V

2231:
2232:
2233: Cursor l_chrv_csr Is
2234: select 'x'
2235: from OKX_QP_LIST_LINES_V
2236: where ID1 = p_clev_rec.price_list_line_id;
2237:
2238: Begin
2239:

Line 2539: FROM QP_LIST_LINES

2535: FROM QP_LIST_HEADERS_B
2536: WHERE LIST_HEADER_ID = p_clev_rec.ph_qp_reference_id;
2537: Cursor l_tmp_2_csr Is
2538: SELECT 'x'
2539: FROM QP_LIST_LINES
2540: WHERE LIST_LINE_ID = p_clev_rec.ph_qp_reference_id;
2541: BEGIN
2542: IF (l_debug = 'Y') THEN
2543: okc_debug.Set_Indentation('OKC_CLE_PVT');

Line 2558: ELSE -- subline should point to QP_LIST_LINES

2554: IF p_clev_rec.cle_id IS NULL THEN -- top level line should point to QP_LIST_HEADERS
2555: Open l_tmp_1_csr;
2556: Fetch l_tmp_1_csr Into l_dummy_var;
2557: Close l_tmp_1_csr;
2558: ELSE -- subline should point to QP_LIST_LINES
2559: Open l_tmp_2_csr;
2560: Fetch l_tmp_2_csr Into l_dummy_var;
2561: Close l_tmp_2_csr;
2562: END IF;