DBA Data[Home] [Help]

APPS.OKL_LEGAL_ENTITY_UTIL dependencies on OKL_K_HEADERS

Line 67: FROM okl_k_headers khr

63: IS
64: CURSOR get_le_id_csr(p_khr_id IN NUMBER)
65: IS
66: SELECT khr.legal_entity_id
67: FROM okl_k_headers khr
68: WHERE khr.id = p_khr_id;
69:
70: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE := NULL;
71:

Line 87: FROM okl_k_headers khr,okc_k_lines_b okc_ln

83: IS
84: CURSOR get_le_id_csr(p_kle_id1 IN NUMBER)
85: IS
86: SELECT khr.legal_entity_id
87: FROM okl_k_headers khr,okc_k_lines_b okc_ln
88: WHERE khr.id = okc_ln.dnz_chr_id
89: -- AND okc_ln.chr_id =okc_ln.dnz_chr_id
90: AND okc_ln.id = p_kle_id1;
91: