DBA Data[Home] [Help]

APPS.OKC_PRICE_PUB dependencies on OKC_K_HEADERS_B

Line 635: from okc_k_headers_b

631: x_cur_code OUT NOCOPY Varchar2,
632: x_return_status OUT NOCOPY Varchar2) Is
633: cursor c1(p_chr_id Number) is
634: select currency_code
635: from okc_k_headers_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,

Line 639: from okc_k_headers_b k,

635: from okc_k_headers_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;

Line 714: From OKC_K_HEADERS_B

710: Cursor Get_Hdr_det_Csr (p_hdr_id Number) Is
711: Select Currency_code
712: ,Cust_po_number
713: ,scs_code
714: From OKC_K_HEADERS_B
715: Where id = p_hdr_id;
716:
717: Cursor Get_agreement_Csr(p_id Number) Is
718: Select Isa_Agreement_id