DBA Data[Home] [Help]

APPS.OKL_STREAMS_WF dependencies on OKL_STREAM_INTERFACES

Line 46: FROM okl_stream_interfaces

42: -- smahapat added khr_id to cursor for bug 3145238
43: CURSOR strm_interfaces_data_csr (p_trx_number NUMBER) IS
44: SELECT
45: ORP_CODE, KHR_ID
46: FROM okl_stream_interfaces
47: WHERE okl_stream_interfaces.transaction_number = p_trx_number;
48:
49: -- smahapat added for bug 3145238
50: -- cursor to provide information for setting context

Line 47: WHERE okl_stream_interfaces.transaction_number = p_trx_number;

43: CURSOR strm_interfaces_data_csr (p_trx_number NUMBER) IS
44: SELECT
45: ORP_CODE, KHR_ID
46: FROM okl_stream_interfaces
47: WHERE okl_stream_interfaces.transaction_number = p_trx_number;
48:
49: -- smahapat added for bug 3145238
50: -- cursor to provide information for setting context
51: CURSOR l_hdr_csr(chrId NUMBER)