[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT okl_sif_seq.nextval
FROM dual;
SELECT
sum(ste.amount)
FROM
OKL_STRM_ELEMENTS STE,
OKL_STREAMS STM,
OKL_STRM_TYPE_V STY
WHERE ste.amount <> 0
AND stm.id = ste.stm_id
AND sty.id IN (p_invdisbas_sty_id) -- pick INVESTOR RENT DISB BASIS streams only
AND ste.date_billed IS NOT NULL -- already disbursed (fake and real both)
AND stm.active_yn = 'Y' -- always active streams only
AND stm.say_code = 'CURR' -- always current streams only
AND sty.id = stm.sty_id
AND stm.kle_id = p_kle_id -- for the terminated asset
AND ste.stream_element_date > p_quote_eff_date -- pick streams greater than termination date
AND stm.source_id = p_ia_id;
SELECT
sum(ste.amount)
FROM
OKL_STRM_ELEMENTS STE,
OKL_STREAMS STM,
OKL_STRM_TYPE_V STY,
OKL_STRM_ELEMENTS BILLED_STE
WHERE ste.amount <> 0
AND stm.id = ste.stm_id
AND sty.id IN (p_invdisbas_sty_id) -- pick INVESTOR RENT DISB BASIS streams only
AND ste.date_billed IS NULL -- NOT YET disbursed (fake or real)
AND ste.sel_id = billed_ste.id -- original billing stream was billed
AND billed_ste.date_billed IS NOT NULL
AND stm.active_yn = 'Y' -- always active streams only
AND stm.say_code = 'CURR' -- always current streams only
AND sty.id = stm.sty_id
AND stm.kle_id = p_kle_id -- for the terminated asset
AND ste.stream_element_date > p_quote_eff_date -- pick streams greater than termination date
AND stm.source_id = p_ia_id ;
SELECT okl_sif_seq.nextval
FROM dual;
SELECT
sum(ste.amount)
FROM
OKL_STRM_ELEMENTS STE,
OKL_STREAMS STM,
OKL_STRM_TYPE_V STY
WHERE ste.amount <> 0
AND stm.id = ste.stm_id
AND sty.id IN (p_invdisbas_sty_id,p_intdisbas_sty_id) -- pick INVESTOR Principal,interest DISB BASIS streams only
AND ste.date_billed IS NOT NULL -- already disbursed (fake and real both)
AND stm.active_yn = 'Y' -- always active streams only
AND stm.say_code = 'CURR' -- always current streams only
AND sty.id = stm.sty_id
AND stm.kle_id = p_kle_id -- for the terminated asset
AND ste.stream_element_date > p_quote_eff_date -- pick streams greater than termination date
AND stm.source_id = p_ia_id;
SELECT
sum(ste.amount)
FROM
OKL_STRM_ELEMENTS STE,
OKL_STREAMS STM,
OKL_STRM_TYPE_V STY,
OKL_STRM_ELEMENTS BILLED_STE
WHERE ste.amount <> 0
AND stm.id = ste.stm_id
AND sty.id IN (p_invdisbas_sty_id,p_intdisbas_sty_id) -- pick INVESTOR Principal,interest DISB BASIS streams only
AND ste.date_billed IS NULL -- NOT YET disbursed (fake or real)
AND ste.sel_id = billed_ste.id -- original billing stream was billed
AND billed_ste.date_billed IS NOT NULL
AND stm.active_yn = 'Y' -- always active streams only
AND stm.say_code = 'CURR' -- always current streams only
AND sty.id = stm.sty_id
AND stm.kle_id = p_kle_id -- for the terminated asset
AND ste.stream_element_date > p_quote_eff_date -- pick streams greater than termination date
AND stm.source_id = p_ia_id ;
SELECT okl_sif_seq.nextval
FROM dual;
SELECT KHR_ID,
NVL(PARTIAL_YN, 'N') PARTIAL_YN,
date_effective_from, -- rmunjulu EDAT 24-Nov-04
date_accepted -- rmunjulu EDAT 24-Nov-04
FROM OKL_TRX_QUOTES_V
WHERE ID = c_quote_id;
SELECT CHR_ID
FROM OKC_K_LINES_B
WHERE ID = c_kle_id;
SELECT KLE_ID, -- STY_ID,
SUM(AMOUNT) AMOUNT
--, QLT_CODE
FROM OKL_TXL_QUOTE_LINES_B
WHERE QTE_ID = c_quote_id
AND QLT_CODE IN ('AMBCOC','AMCTUR','AMCTOC') -- qualify as CO lines
GROUP BY KLE_ID, STY_ID, QLT_CODE
ORDER BY KLE_ID;
SELECT STM.id
FROM OKL_STREAMS_V STM,
OKL_STRM_TYPE_B STY
WHERE STM.khr_id = c_khr_id
AND STM.kle_id = c_kle_id
AND STM.say_code = 'CURR'
AND STM.STY_ID = STY.ID
AND stream_type_subclass = 'RESIDUAL';
SELECT KLE_ID,
0 AMOUNT
FROM OKL_TXL_QUOTE_LINES_B
WHERE QTE_ID = c_quote_id
AND QLT_CODE IN ('AMCFIA');
SELECT TRUNC(MAX(POX.DATE_EFFECTIVE))
FROM OKL_POOL_CONTENTS POC,
OKL_POOL_TRANSACTIONS POX
WHERE POC.KHR_ID = p_khr_id
AND POC.STY_CODE = p_sty_code
AND POX.POL_ID = POC.POL_ID
AND POX.TRANSACTION_NUMBER = POC.TRANSACTION_NUMBER_IN
AND POX.TRANSACTION_REASON = 'BUY_BACK';
SELECT POOL.KHR_ID IA_ID
, POC.STREAMS_TO_DATE
FROM OKL_POOL_CONTENTS POC
, OKL_POOLS POOL
WHERE POOL.ID = POC.POL_ID
AND POC.KHR_ID = p_khr_id
AND POC.KLE_ID = p_kle_id
AND POC.STATUS_CODE = 'ACTIVE'
AND EXISTS (SELECT '1'
FROM OKL_STREAMS STMB,
OKL_STRM_TYPE_B STYB
WHERE stmb.sty_id = styb.id
AND stmb.khr_id = POC.khr_id
AND stmb.kle_id = POC.kle_id
AND stmb.id = POC.stm_id
AND styb.stream_type_subclass =p_sty_code
)
ORDER BY POC.STREAMS_TO_DATE DESC;
SELECT deal_type
FROM OKL_K_HEADERS khr
WHERE khr.id = p_khr_id;
SELECT sysdate INTO l_sysdate FROM dual;
l_asset_tbl.DELETE;
,'calling OKL_STREAMS_PUB.update_streams');
OKL_STREAMS_PUB.update_streams(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_stmv_tbl => lp_stmv_tbl,
x_stmv_tbl => lx_stmv_tbl);
,'returning from OKL_STREAMS_PUB.update_streams'
||', status is '||l_return_status);
l_asset_tbl.DELETE;
SELECT okl_sif_seq.nextval
FROM dual;
SELECT okl_sif_seq.nextval
FROM dual;
SELECT okl_sif_seq.nextval
FROM dual;