APPS.OKL_VAR_INT_REAMORT_PVT dependencies on OKL_STREAMS

Line 358: okl_streams stm,

354: from
355: okl_K_lines_full_v kle,
356: okc_statuses_b sts,
357: okl_strm_elements sel,
358: okl_streams stm,
359: okl_strm_type_b sty
360: WHERE kle.dnz_chr_id = p_chr_id
361: AND kle.id = p_kle_id
362: AND kle.sts_code = sts.code

Line 379: okl_streams str,

375:
376: Cursor l_chr_rents_csr (p_chr_id NUMBER, p_kle_id NUMBER, p_date DATE, p_advance_or_arrears VARCHAR2) IS
377: SELECT NVL(SUM(sele.amount),0) amount
378: FROM okl_strm_elements sele,
379: okl_streams str,
380: okl_strm_type_b sty
381: WHERE sele.stm_id = str.id
382: AND str.sty_id = sty.id
383: AND sty.stream_type_purpose = 'RENT'

Line 451: okl_streams stm,

447: from
448: okl_K_lines_full_v kle,
449: okc_statuses_b sts,
450: okl_strm_elements sel,
451: okl_streams stm,
452: okl_strm_type_b sty
453: WHERE kle.dnz_chr_id = p_chr_id
454: AND kle.id = p_kle_id
455: AND kle.sts_code = sts.code

Line 866: OKL_STREAMS_UTIL.get_line_id(p_trx_number => p_trx_number

862: p_index_number IN NUMBER,
863: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER IS
864: l_kle_id NUMBER := -9999;
865: BEGIN
866: OKL_STREAMS_UTIL.get_line_id(p_trx_number => p_trx_number
867: ,p_index_number => p_index_number
868: ,x_kle_id => l_kle_id
869: ,x_return_status => x_return_status);
870: RETURN l_kle_id;