eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_BPD_TERMINATION_ADJ_PVT dependencies on OKC_K_LINES_B

Line 352: FROM okc_k_lines_b kle,

348:
349: l_status_code OKC_STATUSES_B.CODE%TYPE := NULL;
350:
351: cursor l_kle_status_code_csr(cp_kle_id IN NUMBER) IS SELECT ste_code
352: FROM okc_k_lines_b kle,
353: okc_statuses_b kls
354: WHERE kle.id = cp_kle_id
355: AND kle.sts_code = kls.code;
356: BEGIN

Line 416: okc_k_lines_b kle,

412: okl_streams stm,
413: okl_strm_type_v sty,
414: okc_k_headers_b khr,
415: okl_k_headers khl,
416: okc_k_lines_b kle,
417: okc_statuses_b khs
418: WHERE trunc(ste.stream_element_date) > trunc(nvl(cp_term_date_from, ste.stream_element_date))
419: AND trunc(ste.stream_element_date) <= trunc(nvl(cp_term_date_to, ste.stream_element_date))
420: AND ste.amount <> 0

Line 441: CURSOR l_lnk_ast_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS

437: AND OKL_BPD_TERMINATION_ADJ_PVT.get_kle_status_code(stm.kle_id) IN ('ACTIVE', 'TERMINATED', 'HEADER_LEVEL')
438: ORDER BY 1, 2, 3;
439: -- akrangan bug 5655680 -- start
440: --cursor to check if financial asset appears as linked asset
441: CURSOR l_lnk_ast_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
442: Select lnk.id link_kle_id
443: --lnk.cle_id link_kle_id
444: From okc_k_lines_b lnk,
445: okc_line_styles_b lnk_lse,

Line 444: From okc_k_lines_b lnk,

440: --cursor to check if financial asset appears as linked asset
441: CURSOR l_lnk_ast_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
442: Select lnk.id link_kle_id
443: --lnk.cle_id link_kle_id
444: From okc_k_lines_b lnk,
445: okc_line_styles_b lnk_lse,
446: okc_statuses_b sts,
447: okc_k_items cim
448: Where lnk.id = cim.cle_id

Line 567: okc_k_lines_b kle,

563: okl_streams stm,
564: okl_strm_type_v sty,
565: okc_k_headers_b khr,
566: okl_k_headers khl,
567: okc_k_lines_b kle,
568: okc_statuses_b khs
569: WHERE trunc(ste.stream_element_date) >= trunc(nvl(cp_term_date_from, ste.stream_element_date))
570: AND trunc(ste.stream_element_date) <= trunc(nvl(cp_term_date_to, ste.stream_element_date))
571: AND ste.amount <> 0

Line 774: okc_k_lines_b kle,

770: okl_streams stm,
771: okl_strm_type_v sty,
772: okc_k_headers_b khr,
773: okl_k_headers khl,
774: okc_k_lines_b kle,
775: okc_statuses_b khs
776: WHERE trunc(ste.stream_element_date) >= trunc(nvl(cp_term_date_from, ste.stream_element_date))
777: AND trunc(ste.stream_element_date) <= trunc(nvl(cp_term_date_to, ste.stream_element_date))
778: AND ste.amount <> 0