DBA Data[Home] [Help]

APPS.OKL_POOL_PVT dependencies on OKL_POOL_STREAMS_UV

Line 4243: FROM OKL_POOL_STREAMS_UV pols

4239: FROM okl_pool_contents poc
4240: WHERE poc.pol_id = p_pol_id
4241: AND NOT EXISTS
4242: ( SELECT '1'
4243: FROM OKL_POOL_STREAMS_UV pols
4244: WHERE poc.stm_id = pols.stm_id
4245: AND pols.stream_say_code = 'CURR'
4246: AND pols.stream_active_yn = 'Y'
4247: -- mvasudev, 02/06/2004

Line 4408: FROM OKL_POOL_STREAMS_UV pols

4404: FROM okl_pool_contents poc
4405: WHERE poc.pol_id = p_pol_id
4406: AND NOT EXISTS
4407: ( SELECT '1'
4408: FROM OKL_POOL_STREAMS_UV pols
4409: WHERE poc.stm_id = pols.stm_id
4410: AND pols.stream_say_code = 'CURR'
4411: AND pols.stream_active_yn = 'Y'
4412: -- mvasudev, 02/06/2004