APPS.OKL_QA_SECURITIZATION dependencies on OKL_POOLS

Line 32: from okl_pools

28:
29: /* Bug# 2924696
30: CURSOR l_princ_csr ( chrID NUMBER ) IS
31: select nvl( total_principal_amount, -1) princi
32: from okl_pools
33: where khr_id = chrID;
34:
35: l_princ_rec l_princ_csr%ROWTYPE;
36: */

Line 45: FROM okl_pools pool, okl_pool_contents pcon

41: l_cn l_contract_name%ROWTYPE;
42:
43: CURSOR l_rev_strm_check_csr(p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
44: SELECT distinct pool.khr_id, pcon.sty_id, pcon.sty_code
45: FROM okl_pools pool, okl_pool_contents pcon
46: WHERE pool.id = pcon.pol_id
47: AND pool.khr_id = p_chr_id
48: AND not exists (
49: SELECT 'Y'

Line 123: okl_pools polb,

119: -- To check if the stream type subclass has been securitized.
120: CURSOR l_okl_poc_sty_subclass_csr(p_agreement_id IN NUMBER, p_stream_type_subclass IN VARCHAR2) IS
121: SELECT 1
122: FROM okl_pool_contents pocb,
123: okl_pools polb,
124: okl_strm_type_b styb
125: WHERE polb.khr_id = p_agreement_id
126: AND pocb.pol_id = polb.id
127: AND pocb.sty_id = styb.id

Line 866: FROM okl_pool_contents poc, okl_pools pol

862: ) IS
863:
864: CURSOR get_chr_id (p_chr_id IN NUMBER) IS
865: SELECT DISTINCT(poc.khr_id)
866: FROM okl_pool_contents poc, okl_pools pol
867: WHERE pol.khr_id = p_chr_id
868: AND pol.id = poc.pol_id;
869:
870: -- Get the sec type for the ia, convert the old product --

Line 877: FROM okl_pool_contents a, okc_k_headers_b b,okl_k_headers c, okl_pools d

873: SELECT a.khr_id,
874: decode(c.securitization_type, 'SALE','SECURITIZATION','LOAN','SYNDICATION',
875: 'SECURITIZATION','SECURITIZATION','SYNDICATION','SYNDICATION') securitization_type,
876: b.contract_number
877: FROM okl_pool_contents a, okc_k_headers_b b,okl_k_headers c, okl_pools d
878: WHERE a.khr_id = p_khr_id
879: AND a.pol_id=d.id
880: AND d.khr_id= c.id
881: AND b.id=c.id;