APPS.OKL_BPD_TERMINATION_ADJ_PVT dependencies on OKC_STATUSES_B

Line 349: l_status_code OKC_STATUSES_B.CODE%TYPE := NULL;

345: ---------------------------------------------------------------------------
346:
347: FUNCTION get_kle_status_code(p_kle_id IN NUMBER) RETURN VARCHAR2 IS
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

Line 353: okc_statuses_b kls

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
357: if (p_kle_id IS NOT NULL) THEN

Line 417: okc_statuses_b khs

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
421: AND stm.id = ste.stm_id

Line 446: okc_statuses_b sts,

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
449: and lnk.dnz_chr_id = cim.dnz_chr_id
450: and lnk.lse_id = lnk_lse.id

Line 568: okc_statuses_b khs

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
572: AND stm.id = ste.stm_id

Line 775: okc_statuses_b khs

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
779: AND stm.id = ste.stm_id