DBA Data[Home] [Help]

APPS.OKC_PAV_PVT dependencies on OKC_K_LINES_B

Line 1722: FROM Okc_K_Lines_B

1718: l_okc_chrv_pk okc_chrv_pk_csr%ROWTYPE;
1719: CURSOR okc_clev_pk_csr (p_id IN NUMBER) IS
1720: SELECT
1721: 'x'
1722: FROM Okc_K_Lines_B
1723: WHERE okc_k_lines_b.id = p_id;
1724: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
1725: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1726: l_row_notfound BOOLEAN := TRUE;

Line 1723: WHERE okc_k_lines_b.id = p_id;

1719: CURSOR okc_clev_pk_csr (p_id IN NUMBER) IS
1720: SELECT
1721: 'x'
1722: FROM Okc_K_Lines_B
1723: WHERE okc_k_lines_b.id = p_id;
1724: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
1725: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1726: l_row_notfound BOOLEAN := TRUE;
1727: BEGIN

Line 7417: FROM OKC_K_LINES_B

7413: p_major_version
7414: FROM okc_price_att_values
7415: WHERE cle_id IN
7416: (SELECT id
7417: FROM OKC_K_LINES_B
7418: WHERE dnz_chr_id = p_chr_id
7419: );
7420:
7421: RETURN l_return_status;

Line 8108: FROM OKC_K_LINES_B

8104: object_version_number
8105: FROM okc_price_att_values_h
8106: WHERE cle_id IN
8107: (SELECT id
8108: FROM OKC_K_LINES_B
8109: WHERE dnz_chr_id = p_chr_id
8110: )
8111: AND major_version = p_major_version;
8112: