APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_STRM_TYPE_B

Line 4360: OKL_STRM_TYPE_B STY

4356: -- Modified cursor by passing sty_id based on the purpose .
4357: CURSOR k_streams_csr ( p_chr_id IN NUMBER,p_sty_id IN NUMBER) IS
4358: SELECT STM.id
4359: FROM OKL_STREAMS_V STM,
4360: OKL_STRM_TYPE_B STY
4361: WHERE STM.khr_id = p_chr_id
4362: AND STM.say_code = 'CURR'
4363: AND STM.STY_ID = STY.ID
4364: AND STY.ID NOT IN (nvl(p_sty_id, OKL_API.G_MISS_NUM)) -- rmunjulu 4058630 check for NVL

Line 6259: okl_strm_type_b sty

6255: SELECT sty.id Primary_sty_id, sty.code,okc_line.id kle_id
6256: FROM okc_k_lines_b okc_line,
6257: okc_line_styles_b lse,
6258: okc_k_items item,
6259: okl_strm_type_b sty
6260: WHERE okc_line.dnz_chr_id = p_khr_id
6261: AND okc_line.lse_id = lse.id
6262: AND lse.lty_code = 'FEE'
6263: AND item.cle_id = okc_line.id