[Home] [Help]
999: SELECT SEL.id
1000: FROM OKL_STREAMS_V STM,
1001: OKL_STRM_ELEMENTS_V SEL,
1002: OKC_K_HEADERS_V KHR,
1003: OKL_STRM_TYPE_B STY
1004: WHERE KHR.id = p_khr_id
1005: AND KHR.id = STM.khr_id
1006: AND STM.id = SEL.stm_id
1007: AND STM.say_code = 'CURR'
1021: FROM OKC_K_HEADERS_B CHR
1022: WHERE id = p_chr_id
1023: AND EXISTS (
1024: SELECT 1
1025: FROM OKL_STRM_TYPE_B sty,
1026: OKL_STREAMS stm,
1027: OKL_STRM_ELEMENTS ste,
1028: OKL_PROD_STRM_TYPES_V psty,
1029: OKL_K_HEADERS khr