DBA Data[Home] [Help]

APPS.OKL_SEC_CONCURRENT_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 142: ,okc_k_headers_all_b chrb

138: IS
139: SELECT okxv.name
140: ,chrb.currency_code
141: FROM OKX_PARTIES_V okxv
142: ,okc_k_headers_all_b chrb
143: ,okc_k_lines_b cleb
144: ,okc_k_party_roles_b cplb
145: WHERE cleb.id = p_id
146: AND cleb.dnz_chr_id = chrb.id

Line 680: FROM OKC_K_HEADERS_ALL_B CHRB

676: --Bug 6691554 - Start of Changes
677: CURSOR get_ia_status_csr(p_chr_id NUMBER)
678: IS
679: SELECT chrb.sts_code
680: FROM OKC_K_HEADERS_ALL_B CHRB
681: WHERE CHRB.ID = p_chr_id;
682:
683: l_status_code OKC_K_HEADERS_ALL_B.STS_CODE%TYPE;
684: --Bug 6691554 - End of Changes

Line 683: l_status_code OKC_K_HEADERS_ALL_B.STS_CODE%TYPE;

679: SELECT chrb.sts_code
680: FROM OKC_K_HEADERS_ALL_B CHRB
681: WHERE CHRB.ID = p_chr_id;
682:
683: l_status_code OKC_K_HEADERS_ALL_B.STS_CODE%TYPE;
684: --Bug 6691554 - End of Changes
685:
686: BEGIN
687: