APPS.OKL_STREAMS_UTIL dependencies on OKL_SIF_RET_LEVELS

Line 2756: p_index_number IN okl_sif_ret_levels.INDEX_NUMBER%TYPE,

2752: -- End of Commnets
2753: --------------------------------------------------------------------------------
2754: PROCEDURE get_line_id(
2755: p_trx_number IN okl_stream_interfaces.TRANSACTION_NUMBER%TYPE,
2756: p_index_number IN okl_sif_ret_levels.INDEX_NUMBER%TYPE,
2757: x_kle_id OUT NOCOPY NUMBER,
2758: x_return_status OUT NOCOPY VARCHAR2)
2759: AS
2760: --Curosor to fetch the line_id from the stream interface tables

Line 2765: FROM OKL_SIF_RET_LEVELS SRLB,

2761: CURSOR kle_id_csr(p_trx_number IN NUMBER,
2762: p_index_number IN NUMBER)
2763: IS
2764: SELECT SILB.KLE_ID
2765: FROM OKL_SIF_RET_LEVELS SRLB,
2766: OKL_SIF_RETS SIRB,
2767: OKL_STREAM_INTERFACES SIFB,
2768: OKL_SIF_LINES SILB
2769: WHERE SIFB.TRANSACTION_NUMBER = p_trx_number