DBA Data[Home] [Help]

APPS.OKL_TXL_ITM_INSTS_PVT dependencies on OKL_TXL_ASSETS_B

Line 378: CURSOR get_chr_id(p_kle_id OKL_TXL_ASSETS_B.KLE_ID%TYPE)

374: IS
375: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TXL_ITM_INSTS';
376: ln_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
377: -- Bug# 3477560
378: CURSOR get_chr_id(p_kle_id OKL_TXL_ASSETS_B.KLE_ID%TYPE)
379: IS
380: SELECT cle.dnz_chr_id
381: FROM okc_k_lines_b cle
382: WHERE cle.id = p_kle_id;

Line 597: CURSOR get_chr_id(p_kle_id OKL_TXL_ASSETS_B.KLE_ID%TYPE)

593: IS
594: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TXL_ITM_INSTS';
595: ln_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
596: -- Bug# 3477560
597: CURSOR get_chr_id(p_kle_id OKL_TXL_ASSETS_B.KLE_ID%TYPE)
598: IS
599: SELECT cle.dnz_chr_id
600: FROM okc_k_lines_b cle
601: WHERE cle.id = p_kle_id;