[Home] [Help]
85: FROM okl_pool_contents opc,
86: okl_pools op,
87: okl_k_headers khr,
88: -- Changed for User Defined Streams
89: --okl_strm_type_tl stytl
90: okl_strm_type_b stytl
91: WHERE op.khr_id = p_inv_id
92: AND opc.khr_id = p_khr_id
93: AND op.id = opc.pol_id
129: FROM okl_pool_contents opc,
130: okl_pools op,
131: okl_k_headers khr,
132: -- Changed for User Defined Streams
133: --okl_strm_type_tl stytl
134: okl_strm_type_b stytl
135: WHERE op.khr_id = p_inv_id
136: AND opc.khr_id = p_khr_id
137: AND op.id = opc.pol_id
199: -- cursor to get stream type id
200: CURSOR get_sty_id_csr (p_sty_name VARCHAR2)
201: IS
202: SELECT id
203: FROM okl_strm_type_tl
204: WHERE name = p_sty_name
205: AND language = USERENV('LANG');
206:
207: /* ankushar , 25-01-2008 Bug 6773285