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 448: okc_statuses_b sts,

444: Select lnk.id link_kle_id
445: --lnk.cle_id link_kle_id
446: From okc_k_lines_b lnk,
447: okc_line_styles_b lnk_lse,
448: okc_statuses_b sts,
449: okc_k_items cim
450: Where lnk.id = cim.cle_id
451: and lnk.dnz_chr_id = cim.dnz_chr_id
452: and lnk.lse_id = lnk_lse.id

Line 644: okc_statuses_b khs

640: okl_strm_type_v sty,
641: okc_k_headers_b khr,
642: okl_k_headers khl,
643: okc_k_lines_b kle,
644: okc_statuses_b khs
645: WHERE trunc(ste.stream_element_date) >= trunc(nvl(cp_term_date_from, ste.stream_element_date))
646: AND trunc(ste.stream_element_date) <= trunc(nvl(cp_term_date_to, ste.stream_element_date))
647: AND ste.amount <> 0
648: AND stm.id = ste.stm_id

Line 851: okc_statuses_b khs

847: okl_strm_type_v sty,
848: okc_k_headers_b khr,
849: okl_k_headers khl,
850: okc_k_lines_b kle,
851: okc_statuses_b khs
852: WHERE trunc(ste.stream_element_date) >= trunc(nvl(cp_term_date_from, ste.stream_element_date))
853: AND trunc(ste.stream_element_date) <= trunc(nvl(cp_term_date_to, ste.stream_element_date))
854: AND ste.amount <> 0
855: AND stm.id = ste.stm_id