APPS.OKC_PRICE_PUB dependencies on OKC_K_LINES_B

Line 473: from okc_k_lines_b

469: where cle_id = p_cle_id
470: order by level_sequence desc;
471: cursor c2(p_cle_id Number) is
472: select dnz_chr_id
473: from okc_k_lines_b
474: where id = p_cle_id;
475: Begin
476: -- dbms_output.put_line('Get_Price_List');
477: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 640: okc_k_lines_b b

636: where id = p_chr_id;
637: cursor c2(p_cle_id Number) is
638: select k.currency_code
639: from okc_k_headers_b k,
640: okc_k_lines_b b
641: where b.id = p_cle_id
642: and k.id = b.dnz_chr_id;
643: l_cle_id Number;
644: l_row_notfound Boolean := True;

Line 707: From OKC_K_LINES_B

703: Select dnz_chr_id
704: ,Start_date
705: ,End_Date
706: ,sts_code
707: From OKC_K_LINES_B
708: Where Id = p_contract_line_id;
709:
710: Cursor Get_Hdr_det_Csr (p_hdr_id Number) Is
711: Select Currency_code