DBA Data[Home] [Help]

APPS.OKC_TGN_PVT dependencies on OKC_K_HEADERS_B

Line 538: FROM Okc_k_headers_b

534: item_not_found_error EXCEPTION;
535: l_row_notfound BOOLEAN := TRUE;
536: CURSOR okc_chrv_pk_csr (p_id IN NUMBER) IS
537: SELECT '1'
538: FROM Okc_k_headers_b
539: WHERE id = p_id;
540: l_okc_chrv_pk okc_chrv_pk_csr%ROWTYPE;
541: BEGIN
542: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 584: FROM okc_condition_headers_b, okc_k_headers_b k

580: CURSOR okc_cnhv_pk_csr (p_id IN NUMBER,
581: p_dnz_chr_id IN NUMBER) IS
582: SELECT
583: '1'
584: FROM okc_condition_headers_b, okc_k_headers_b k
585: WHERE okc_condition_headers_b.id = p_id
586: AND okc_condition_headers_b.dnz_chr_id = p_dnz_chr_id and
587: okc_condition_headers_b.template_yn = k.template_yn and
588: okc_condition_headers_b.dnz_chr_id = k.id;