DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKL_STREAMS_V

Line 4359: FROM OKL_STREAMS_V STM,

4355: -- SMODUGA 11-Oct-04 Bug 3925469
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