APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_STRM_TYPE_B

Line 4477: OKL_STRM_TYPE_B STY

4473: -- Fix for Bug#13933234, sgn_code='INTC' needs to be histrized
4474: CURSOR k_streams_csr ( p_chr_id IN NUMBER,p_sty_id IN NUMBER) IS
4475: SELECT STM.id
4476: FROM OKL_STREAMS_V STM,
4477: OKL_STRM_TYPE_B STY
4478: WHERE STM.khr_id = p_chr_id
4479: AND STM.say_code = 'CURR'
4480: AND STM.STY_ID = STY.ID
4481: AND STY.ID NOT IN (nvl(p_sty_id, OKL_API.G_MISS_NUM)) -- rmunjulu 4058630 check for NVL

Line 6425: okl_strm_type_b sty

6421: SELECT sty.id Primary_sty_id, sty.code,okc_line.id kle_id
6422: FROM okc_k_lines_b okc_line,
6423: okc_line_styles_b lse,
6424: okc_k_items item,
6425: okl_strm_type_b sty
6426: WHERE okc_line.dnz_chr_id = p_khr_id
6427: AND okc_line.lse_id = lse.id
6428: AND lse.lty_code = 'FEE'
6429: AND item.cle_id = okc_line.id