DBA Data[Home] [Help]

APPS.OKL_AM_SECURITIZATION_PVT dependencies on OKL_STRM_TYPE_B

Line 1085: OKL_STRM_TYPE_B STY

1081: CURSOR get_rv_streams_csr(c_khr_id IN NUMBER,
1082: c_kle_id IN NUMBER) IS
1083: SELECT STM.id
1084: FROM OKL_STREAMS_V STM,
1085: OKL_STRM_TYPE_B STY
1086: WHERE STM.khr_id = c_khr_id
1087: AND STM.kle_id = c_kle_id
1088: AND STM.say_code = 'CURR'
1089: AND STM.STY_ID = STY.ID

Line 1128: OKL_STRM_TYPE_B STYB

1124: AND POC.KLE_ID = p_kle_id
1125: AND POC.STATUS_CODE = 'ACTIVE'
1126: AND EXISTS (SELECT '1'
1127: FROM OKL_STREAMS STMB,
1128: OKL_STRM_TYPE_B STYB
1129: WHERE stmb.sty_id = styb.id
1130: AND stmb.khr_id = POC.khr_id
1131: AND stmb.kle_id = POC.kle_id
1132: AND stmb.id = POC.stm_id