APPS.OKL_QA_SECURITIZATION dependencies on OKL_K_LINES

Line 51: okl_k_lines revl,

47: AND pool.khr_id = p_chr_id
48: AND not exists (
49: SELECT 'Y'
50: FROM okc_line_styles_b rev_style,
51: okl_k_lines revl,
52: okc_k_lines_b rev
53: WHERE rev.lse_id = rev_style.id
54: AND rev_style.lty_code = 'REVENUE_SHARE'
55: AND revl.id = rev.id

Line 63: okl_k_lines revl,

59: CURSOR l_rev_strm_comp_csr(p_cle_id IN NUMBER) IS
60: SELECT rev.id, rev.cle_id, revl.sty_id,revl.percent_stake,
61: strm.stream_type_subclass
62: FROM okc_line_styles_b rev_style,
63: okl_k_lines revl,
64: okc_k_lines_b rev,
65: okl_strm_type_v strm
66: WHERE rev.lse_id = rev_style.id
67: AND rev_style.lty_code = 'REVENUE_SHARE'

Line 93: okl_k_lines revl,

89: WHERE stream_type_subclass = 'INVESTOR_DISBURSEMENT'
90: AND not exists (
91: SELECT 'Y'
92: FROM okc_line_styles_b rev_style,
93: okl_k_lines revl,
94: okc_k_lines_b rev
95: WHERE rev.lse_id = rev_style.id
96: AND rev_style.lty_code = 'REVENUE_SHARE'
97: AND revl.id = rev.id

Line 110: FROM okl_k_lines kleb,

106:
107: -- To check if revenue shares exist for each investor.
108: CURSOR l_okl_inv_sty_subclass_csr(p_investor_id IN NUMBER, p_stream_type_subclass IN VARCHAR2) IS
109: SELECT 1
110: FROM okl_k_lines kleb,
111: okc_k_lines_b cles,
112: okc_line_styles_b lseb
113: WHERE kleb.id = cles.id
114: AND cles.lse_id = lseb.id

Line 133: FROM okl_k_lines kleb,

129:
130: --Bug# 5032252 --start
131: CURSOR l_rev_share_per_csr(p_investor_id IN NUMBER, p_stream_type_subclass IN VARCHAR2) IS
132: SELECT kleb.percent_stake
133: FROM okl_k_lines kleb,
134: okc_k_lines_b cles,
135: okc_line_styles_b lseb
136: WHERE kleb.id = cles.id
137: AND cles.lse_id = lseb.id

Line 149: , okl_k_lines kle

145: select hzp.party_name partyname
146: , okl_strmtyp.name streamtypename
147: FROM okc_k_lines_b cle
148: , okc_line_styles_b lse
149: , okl_k_lines kle
150: , okc_k_party_roles_b parb
151: , hz_parties hzp
152: , okc_k_items cit
153: , okl_strmtyp_source_v okl_strmtyp

Line 181: FROM okl_k_lines kleb,

177: --Bug 6773285 - Start of Changes
178: CURSOR l_rev_share_dtls_csr(p_investor_id IN NUMBER) IS
179: SELECT kleb.stream_type_subclass,
180: kleb.percent_stake
181: FROM okl_k_lines kleb,
182: okc_k_lines_b cles,
183: okc_line_styles_b lseb
184: WHERE kleb.id = cles.id
185: AND cles.lse_id = lseb.id

Line 214: l_rev_share_per okl_k_lines.PERCENT_STAKE%TYPE;

210: */
211: l_api_version CONSTANT NUMBER := 1.0;
212:
213: --Bug# 5032252
214: l_rev_share_per okl_k_lines.PERCENT_STAKE%TYPE;
215: BEGIN
216: -- initialize return status
217: x_return_status := OKL_API.G_RET_STS_SUCCESS;
218: