The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT '1'
FROM okl_pool_contents pocb,
okl_pools polb,
okc_k_headers_b chrb
WHERE pocb.pol_id = polb.id
AND polb.khr_id = chrb.id -- inv agreement
AND chrb.sts_code = G_STS_CODE_ACTIVE
AND pocb.khr_id = p_khr_id
AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) >= TRUNC(p_effective_date)
AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND EXISTS (SELECT '1'
FROM okl_streams stmb,
okl_strm_type_b styb
WHERE stmb.sty_id = styb.id
AND stmb.khr_id = pocb.khr_id
AND stmb.id = pocb.stm_id
AND NVL(styb.stream_type_subclass,'x')
= NVL(p_stream_type_subclass, NVL(styb.stream_type_subclass,'x'))
);
SELECT '1'
FROM okl_pool_contents pocb,
okl_pools polb,
okc_k_headers_b chrb
WHERE pocb.pol_id = polb.id
AND polb.khr_id = chrb.id -- inv agreement
AND chrb.sts_code = G_STS_CODE_ACTIVE
AND pocb.khr_id = p_khr_id
AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) > TRUNC(p_effective_date)
AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND EXISTS (SELECT '1'
FROM okl_streams stmb,
okl_strm_type_b styb
WHERE stmb.sty_id = styb.id
AND stmb.khr_id = pocb.khr_id
AND stmb.id = pocb.stm_id
AND NVL(styb.stream_type_subclass,'x')
= NVL(p_stream_type_subclass, NVL(styb.stream_type_subclass,'x'))
);
SELECT '1'
FROM okl_pool_contents pocb,
okl_pools polb,
okc_k_headers_b chrb
WHERE pocb.pol_id = polb.id
AND polb.khr_id = chrb.id -- inv agreement
AND chrb.sts_code = G_STS_CODE_ACTIVE
AND pocb.khr_id = p_khr_id
AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) < TRUNC(p_effective_date)
AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND EXISTS (SELECT '1'
FROM okl_streams stmb,
okl_strm_type_b styb
WHERE stmb.sty_id = styb.id
AND stmb.khr_id = pocb.khr_id
AND stmb.id = pocb.stm_id
AND NVL(styb.stream_type_subclass,'x')
= NVL(p_stream_type_subclass, NVL(styb.stream_type_subclass,'x'))
);
SELECT '1'
FROM okl_pool_contents pocb,
okl_pools polb,
okc_k_headers_b chrb
WHERE pocb.pol_id = polb.id
AND polb.khr_id = chrb.id -- inv agreement
AND chrb.sts_code = G_STS_CODE_ACTIVE
AND pocb.khr_id = p_khr_id
AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) = TRUNC(p_effective_date)
AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND EXISTS (SELECT '1'
FROM okl_streams stmb,
okl_strm_type_b styb
WHERE stmb.sty_id = styb.id
AND stmb.khr_id = pocb.khr_id
AND stmb.id = pocb.stm_id
AND NVL(styb.stream_type_subclass,'x')
= NVL(p_stream_type_subclass, NVL(styb.stream_type_subclass,'x'))
);
SELECT ph.khr_id -- inv agreemnet id
FROM okl_pools ph
WHERE EXISTS (SELECT '1'
FROM okl_pool_contents pl
WHERE pl.pol_id = ph.id
AND pl.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND pl.khr_id = p_khr_id) -- lease contract id
;
SELECT '1'
FROM okl_pool_contents pocb,
okl_pools polb,
okc_k_headers_b chrb
WHERE pocb.pol_id = polb.id
AND polb.khr_id = chrb.id -- inv agreement
AND chrb.sts_code = G_STS_CODE_ACTIVE
AND pocb.kle_id = p_kle_id
AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) >= TRUNC(p_effective_date)
AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND EXISTS (SELECT '1'
FROM okl_streams stmb,
okl_strm_type_b styb
WHERE stmb.sty_id = styb.id
AND stmb.khr_id = pocb.khr_id
AND stmb.kle_id = pocb.kle_id
AND stmb.id = pocb.stm_id
AND NVL(styb.stream_type_subclass,'x')
= NVL(p_stream_type_subclass, NVL(styb.stream_type_subclass,'x'))
);
SELECT '1'
FROM okl_pool_contents pocb,
okl_pools polb,
okc_k_headers_b chrb
WHERE pocb.pol_id = polb.id
AND polb.khr_id = chrb.id -- inv agreement
AND chrb.sts_code = G_STS_CODE_ACTIVE
AND pocb.kle_id = p_kle_id
AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) > TRUNC(p_effective_date)
AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND EXISTS (SELECT '1'
FROM okl_streams stmb,
okl_strm_type_b styb
WHERE stmb.sty_id = styb.id
AND stmb.khr_id = pocb.khr_id
AND stmb.kle_id = pocb.kle_id
AND stmb.id = pocb.stm_id
AND NVL(styb.stream_type_subclass,'x')
= NVL(p_stream_type_subclass, NVL(styb.stream_type_subclass,'x'))
);
SELECT '1'
FROM okl_pool_contents pocb,
okl_pools polb,
okc_k_headers_b chrb
WHERE pocb.pol_id = polb.id
AND polb.khr_id = chrb.id -- inv agreement
AND chrb.sts_code = G_STS_CODE_ACTIVE
AND pocb.kle_id = p_kle_id
AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) < TRUNC(p_effective_date)
AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND EXISTS (SELECT '1'
FROM okl_streams stmb,
okl_strm_type_b styb
WHERE stmb.sty_id = styb.id
AND stmb.khr_id = pocb.khr_id
AND stmb.kle_id = pocb.kle_id
AND stmb.id = pocb.stm_id
AND NVL(styb.stream_type_subclass,'x')
= NVL(p_stream_type_subclass, NVL(styb.stream_type_subclass,'x'))
);
SELECT '1'
FROM okl_pool_contents pocb,
okl_pools polb,
okc_k_headers_b chrb
WHERE pocb.pol_id = polb.id
AND polb.khr_id = chrb.id -- inv agreement
AND chrb.sts_code = G_STS_CODE_ACTIVE
AND pocb.kle_id = p_kle_id
AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) = TRUNC(p_effective_date)
AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND EXISTS (SELECT '1'
FROM okl_streams stmb,
okl_strm_type_b styb
WHERE stmb.sty_id = styb.id
AND stmb.khr_id = pocb.khr_id
AND stmb.kle_id = pocb.kle_id
AND stmb.id = pocb.stm_id
AND NVL(styb.stream_type_subclass,'x')
= NVL(p_stream_type_subclass, NVL(styb.stream_type_subclass,'x'))
);
SELECT ph.khr_id -- inv agreemnet id
FROM okl_pools ph
WHERE EXISTS (SELECT '1'
FROM okl_pool_contents pl
WHERE pl.pol_id = ph.id
AND pl.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND pl.kle_id = p_kle_id) -- lease contract id
;
SELECT DISTINCT polb.khr_id
FROM okl_pool_contents pocb,
okl_pools polb,
okc_k_headers_b chrb,
okl_strm_type_b styb
WHERE pocb.pol_id = polb.id
AND polb.khr_id = chrb.id -- inv agreement
AND chrb.sts_code = G_STS_CODE_ACTIVE
AND pocb.khr_id = p_khr_id
AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) > TRUNC(p_effective_date)
AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND pocb.sty_id = styb.id;
SELECT DISTINCT polb.khr_id
FROM okl_pool_contents pocb,
okl_pools polb,
okc_k_headers_b chrb,
okl_strm_type_b styb
WHERE pocb.pol_id = polb.id
AND polb.khr_id = chrb.id -- inv agreement
AND chrb.sts_code = G_STS_CODE_ACTIVE
AND pocb.khr_id = p_khr_id
AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) < TRUNC(p_effective_date)
AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND pocb.sty_id = styb.id;
SELECT DISTINCT polb.khr_id
FROM okl_pool_contents pocb,
okl_pools polb,
okc_k_headers_b chrb,
okl_strm_type_b styb
WHERE pocb.pol_id = polb.id
AND polb.khr_id = chrb.id -- inv agreement
AND chrb.sts_code = G_STS_CODE_ACTIVE
AND pocb.khr_id = p_khr_id
AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) = TRUNC(p_effective_date)
AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND pocb.sty_id = styb.id;
SELECT DISTINCT polb.khr_id
FROM okl_pool_contents pocb,
okl_pools polb,
okc_k_headers_b chrb,
okl_strm_type_b styb
WHERE pocb.pol_id = polb.id
AND polb.khr_id = chrb.id -- inv agreement
AND chrb.sts_code = G_STS_CODE_ACTIVE
AND pocb.khr_id = p_khr_id
AND TRUNC(NVL(pocb.streams_to_date,G_FINAL_DATE)) >= TRUNC(p_effective_date)
AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND pocb.sty_id = styb.id;
SELECT '1'
FROM okl_streams strm
,okl_pool_contents pl
,okl_pools ph
,okc_k_headers_b khr
WHERE -- mvasudev, stm_id changes
/*
strm.KHR_ID = pl.KHR_ID
AND strm.KLE_ID = pl.KLE_ID
AND strm.STY_ID = pl.STY_ID
*/
pl.STM_ID = strm.id
-- end, mvasudev, stm_id changes
AND strm.say_code = 'CURR'
AND strm.active_yn = 'Y'
AND pl.pol_id = ph.id
AND ph.khr_id = khr.id -- inv agreement
AND khr.sts_code = G_STS_CODE_ACTIVE
AND strm.id = p_stm_id
--AND pl.streams_from_date <= p_effective_date
AND TRUNC(NVL(pl.streams_to_date,G_FINAL_DATE)) >= TRUNC(p_effective_date)
AND pl.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
;
SELECT '1'
FROM okl_streams strm
,okl_strm_elements ele
,okl_pool_contents pl
,okl_pools ph
,okc_k_headers_b khr
WHERE strm.id = ele.stm_id
-- mvasudev, stm_id changes
/*
AND strm.KHR_ID = pl.KHR_ID
AND strm.KLE_ID = pl.KLE_ID
AND strm.STY_ID = pl.STY_ID
*/
-- end, mvasudev, stm_id changes
AND pl.stm_id = strm.id
AND strm.say_code = 'CURR'
AND strm.active_yn = 'Y'
AND pl.pol_id = ph.id
AND ph.khr_id = khr.id -- inv agreement
AND khr.sts_code = G_STS_CODE_ACTIVE
AND ele.id = p_sel_id
--AND pl.streams_from_date <= p_effective_date
AND TRUNC(NVL(pl.streams_to_date,G_FINAL_DATE)) >= TRUNC(p_effective_date)
AND pl.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
;
SELECT rule_information1
FROM okc_rules_b
WHERE dnz_chr_id = p_ia_chr_id
AND RULE_INFORMATION_CATEGORY='LASEAC';
SELECT lookup_code
FROM fnd_lookups
WHERE lookup_type = 'OKL_FACTORING_SYNDICATION'
AND lookup_code = 'INVESTOR';
SELECT COUNT(khr_id)
FROM okl_pools
WHERE id IN
(SELECT pol_id
FROM okl_pool_contents
WHERE khr_id = p_chr_id
AND TRUNC(streams_from_date) <= TRUNC(p_trx_date) -- cklee 05/29/08
AND (TRUNC(streams_to_date) >= TRUNC(p_trx_date) OR -- cklee 05/29/08
streams_to_date IS NULL)
AND STATUS_CODE ='ACTIVE' -- 5/29/08 cklee fixed bug: 6862849 (R12)/OKL.H # snandiko 6857723
);
SELECT khr_id
FROM okl_pools
WHERE id IN
(SELECT pol_id
FROM okl_pool_contents
WHERE khr_id = p_chr_id
AND TRUNC(streams_from_date) <= TRUNC(p_trx_date) -- cklee 05/29/08
AND (TRUNC(streams_to_date) >= TRUNC(p_trx_date) OR -- cklee 05/29/08
streams_to_date IS NULL)
AND STATUS_CODE ='ACTIVE' -- 5/29/08 cklee fixed bug: 6862849 (R12)/OKL.H # snandiko 6857723
);
SELECT ia.ID ia_id, ia.START_DATE ia_start_date,op.ID pool_id,opc.STY_CODE strm_type,
opc.streams_from_date strm_from_date, opc.streams_to_date strm_to_date
FROM okc_k_headers_b ia,okl_pools op, okl_pool_contents opc
WHERE ia.ID = op.khr_id
AND op.id = opc.pol_id
AND opc.khr_id = p_chr_id
AND opc.STATUS_CODE ='ACTIVE'
AND ia.scs_code = 'INVESTOR'
ORDER by strm_from_date , ia_start_date;
SELECT scs_code
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT MIN(DECODE(rg.RULE_INFORMATION1, G_PROCESS_AUTO_BACK_BACK, G_PRIORITY_2,
G_PROCESS_NOT_ALLOWED, G_PRIORITY_1,
G_PRIORITY_2))
FROM okc_rule_groups_b rgd,
okc_rules_b rg
WHERE rgd.id = rg.rgp_id
AND rgd.rgd_code = p_rgd_code
AND rg.RULE_INFORMATION_CATEGORY = p_rdf_code -- 'LASEPR'
AND EXISTS -- investor agreement Ids
(SELECT '1'
FROM okl_pools ph
,okl_pool_contents pl
WHERE ph.id = pl.pol_id
AND pl.khr_id = p_khr_id -- lease contract id
AND pl.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND ph.khr_id = rg.dnz_chr_id) -- investor agreement contarct id
;
SELECT rgd.dnz_chr_id,
rg.RULE_INFORMATION1
FROM okc_rule_groups_b rgd,
okc_rules_b rg
WHERE rgd.id = rg.rgp_id
AND rgd.rgd_code = p_rgd_code
AND rg.RULE_INFORMATION_CATEGORY = p_rdf_code -- 'LASEPR'
AND EXISTS -- investor agreement Ids
(SELECT '1'
FROM okl_pools ph
,okl_pool_contents pl
WHERE ph.id = pl.pol_id
AND pl.khr_id = p_khr_id -- lease contract id
AND pl.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND ph.khr_id = rg.dnz_chr_id) -- investor agreement contarct id
;
SELECT MIN(DECODE(rg.RULE_INFORMATION1, G_PROCESS_AUTO_BACK_BACK, G_PRIORITY_2,
G_PROCESS_NOT_ALLOWED, G_PRIORITY_1,
G_PRIORITY_2))
FROM okc_rule_groups_b rgd,
okc_rules_b rg
WHERE rgd.id = rg.rgp_id
AND rgd.rgd_code = p_rgd_code
AND rg.RULE_INFORMATION_CATEGORY = p_rdf_code -- 'LASEPR'
AND EXISTS -- investor agreement Ids
(SELECT '1'
FROM okl_pools ph
,okl_pool_contents pl
WHERE ph.id = pl.pol_id
AND pl.kle_id = p_kle_id -- lease contract top line Id
AND pl.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND ph.khr_id = rg.dnz_chr_id) -- investor agreement contarct id
;
SELECT rgd.dnz_chr_id,
rg.RULE_INFORMATION1
FROM okc_rule_groups_b rgd,
okc_rules_b rg
WHERE rgd.id = rg.rgp_id
AND rgd.rgd_code = p_rgd_code
AND rg.RULE_INFORMATION_CATEGORY = p_rdf_code -- 'LASEPR'
AND EXISTS -- investor agreement Ids
(SELECT '1'
FROM okl_pools ph
,okl_pool_contents pl
WHERE ph.id = pl.pol_id
AND pl.kle_id = p_kle_id -- lease contract top line Id
AND pl.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
AND ph.khr_id = rg.dnz_chr_id) -- investor agreement contarct id
;
SELECT pocb.id
FROM okl_pool_contents pocb
,okl_strm_type_b styb
WHERE pocb.khr_id = p_khr_id
AND pocb.pol_id = p_pol_id
AND pocb.sty_id = styb.id
AND styb.stream_type_subclass = p_stream_type_subclass;
SELECT polb.khr_id khr_id -- Investor Agreement
,rulb.rule_information1 formula -- BuyBack Formula
,pocb.khr_id dnz_chr_id -- Lease Contract
-- ,pocb.pol_id pol_id -- Pool
,pocb.kle_id kle_id -- Asset
,pocb.sty_id sty_id -- Stream Type
FROM okl_pool_contents pocb
,okl_pools polb
,okc_rules_b rulb
,okc_rule_groups_v rgpb
WHERE pocb.id = p_poc_id
AND pocb.pol_id = polb.id
AND polb.khr_id = rulb.dnz_chr_id
AND rgpb.rgd_code = 'LASEBB'
AND rulb.rgp_id = rgpb.id
AND rulb.rule_information_category = 'LASEFM';
SELECT DISTINCT pocb.pol_id
FROM okl_pool_contents pocb
,okl_strm_type_b styb
WHERE pocb.khr_id = p_khr_id
AND pocb.pol_id = p_pol_id
AND pocb.sty_id = styb.id
AND styb.stream_type_subclass = p_stream_type_subclass;
SELECT rulb.rule_information1 formula
FROM --okl_pool_contents pocb --changed by abhsaxen for Bug#6174484
--,
okl_pools polb
,okc_rules_b rulb
,okc_rule_groups_v rgpb
WHERE polb.id = p_pol_id
AND polb.khr_id = rulb.dnz_chr_id
AND rgpb.rgd_code = 'LASEBB'
AND rulb.rgp_id = rgpb.id
AND rulb.rule_information_category = 'LASEFM';
SELECT pocb.id poc_id
,polb.khr_id khr_id
,pocb.kle_id kle_id
,pocb.sty_id sty_id
,pocb.sty_code
,pocb.streams_from_date
FROM okl_pool_contents pocb
,okl_strm_type_b styb
,okl_pools polb
WHERE pocb.khr_id = p_khr_id
AND pocb.pol_id = p_pol_id
AND pocb.pol_id = polb.id
AND pocb.status_code = G_POC_STS_ACTIVE
AND pocb.sty_id = styb.id
AND styb.stream_type_subclass = p_stream_type_subclass;
SELECT kleb.percent_stake percent_stake
FROM okl_k_lines kleb
,okc_k_lines_b cles
,okc_line_styles_b lses
,okc_k_lines_b clet
,okc_line_styles_b lset
WHERE clet.dnz_chr_id = p_khr_id
AND clet.lse_id = lset.id
AND lset.lty_code = 'INVESTMENT'
AND cles.cle_id = clet.id
AND cles.lse_id = lses.id
AND lses.lty_code = 'REVENUE_SHARE'
AND kleb.id = cles.id
AND kleb.sty_id = p_sty_id;
SELECT pocb.id
,pocb.kle_id
,pocb.sty_id
,pocb.sty_code
,pocb.streams_from_date
,pocb.streams_to_date
,styb.stream_type_subclass
FROM okl_pool_contents pocb
,okl_strm_type_b styb
WHERE pocb.pol_id = p_pol_id
AND pocb.khr_id = p_khr_id
AND pocb.kle_id = NVL(p_kle_id,pocb.kle_id)
AND pocb.sty_id = styb.id
AND styb.stream_type_subclass = NVL(p_stream_type_subclass,styb.stream_type_subclass)
AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE
AND pocb.transaction_number_out IS NULL;
SELECT id
FROM okl_streams
WHERE khr_id = p_khr_id
AND kle_id = p_kle_id
AND sty_id = p_sty_id
AND say_code = 'CURR'
AND active_yn = 'Y';
SELECT end_date,
sts_code --Bug 6594724
FROM okc_k_headers_b
WHERE id = p_khr_id;
l_rv_date_updated BOOLEAN := FALSE;
l_rv_date_updated := FALSE;
l_rv_date_updated := TRUE;
l_rv_date_updated := TRUE;
Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_pocv_rec => lp_pocv_rec
,x_pocv_rec => lx_pocv_rec);
IF(l_create AND NOT l_rv_date_updated) THEN
--create a new poc record with the above poc details
lp_pocv_rec_cre.pol_id := p_poxv_rec.pol_id;
-- Update Status => "Active"
lp_pocv_rec_upd.id := lx_pocv_rec.id;
Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_pocv_rec => lp_pocv_rec_upd
,x_pocv_rec => lx_pocv_rec);
SELECT DISTINCT pol_id
FROM okl_pool_contents pocb
,okl_strm_type_b styb
WHERE pocb.khr_id = p_khr_id
AND pocb.kle_id = NVL(p_kle_id,pocb.kle_id)
AND pocb.sty_id = styb.id
AND styb.stream_type_subclass = NVL(p_stream_type_subclass,styb.stream_type_subclass)
AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE
AND pocb.transaction_number_out IS NULL;
SELECT end_date
FROM okc_k_headers_b
WHERE id = p_khr_id;
SELECT legal_entity_id
FROM okl_pools
WHERE id = p_pol_id;
SELECT DISTINCT pol_id
FROM okl_pool_contents
WHERE khr_id = p_khr_id
AND kle_id = p_kle_id
AND status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE
AND transaction_number_out IS NULL;
SELECT id
,kle_id
,sty_id
,sty_code
,streams_from_date
,streams_to_date
FROM okl_pool_contents
WHERE pol_id = p_pol_id
AND khr_id = p_khr_id
AND kle_id = p_kle_id
AND status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE
AND transaction_number_out IS NULL;
SELECT id
FROM okl_streams
WHERE khr_id = p_khr_id
AND kle_id = p_kle_id
AND sty_id = p_sty_id
AND say_code = 'CURR'
AND active_yn = 'Y';
SELECT legal_entity_id
FROM okl_pools
WHERE id = p_pol_id;
Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_pocv_rec => lp_pocv_rec
,x_pocv_rec => lx_pocv_rec);
-- Update Status => "Active"
lp_pocv_rec_upd.id := lx_pocv_rec.id;
Okl_Pool_Pvt.update_pool_contents(p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_pocv_rec => lp_pocv_rec_upd
,x_pocv_rec => lx_pocv_rec);
SELECT okl_sif_seq.NEXTVAL transaction_number
FROM dual;
SELECT DISTINCT pocb.pol_id
FROM okl_pool_contents pocb
,okl_strm_type_b styb
WHERE pocb.khr_id = p_khr_id
AND pocb.pol_id = p_pol_id
AND pocb.sty_id = styb.id
AND styb.stream_type_subclass = p_stream_type_subclass;
SELECT khr_id, legal_entity_id
FROM okl_pools
WHERE id = p_pol_id;
SELECT 1
FROM okl_pool_contents pocb
WHERE pocb.khr_id = p_khr_id
AND pocb.status_code = 'ACTIVE';
SELECT id, stream_type_purpose
FROM OKL_STRM_TYPE_B
WHERE stream_type_subclass = p_sty_sub_classs;
-- Update contract header, if needed
l_khr_active := FALSE;
Okl_Contract_Pub.update_contract_header(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_chrv_rec => lp_chrv_rec,
p_khrv_rec => lp_khrv_rec,
x_chrv_rec => lx_chrv_rec,
x_khrv_rec => lx_khrv_rec);